Export and Import Data in SQL Server

Data Pump is a SQL Server Management Studio add-in for filling SQL databases with external source data and migrating data between systems. The tool supports import and export from 10+ widely used data formats (Excel, CSV, XML, JSON, Text, MS Access, etc.) and includes a number of advanced options and templates for recurring scenarios.

Data Pump for SQL Server is a highly customizable solution aiming to facilitate data import and export and thus boost your productivity and accelerate your results.

Import data from 10 most popular data formats
Export data to 14 widely used data formats
Migrate data from third-party databases to SQL Server
Repopulate or append data to database tables
Dump table data to one or multiple SQL files
Use templates for recurring scenarios
Use CLI to schedule and automate data export and import tasks

Supported File Formats

Data Pump supports file transfer between the most frequently used data formats
(Text, MS Excel, XML, CSV, JSON etc.) and allows saving templates for repetitive export and import jobs.

and more...

Learn how to migrate data between databases using Data Pump

Discover how to seamlessly migrate data between databases using dbForge Data Pump. This comprehensive video guide covers everything from exporting and importing data using CSV files to configuring settings, mapping columns, and using templates for recurring tasks.

Try now

Meet the killer feature of dbForge Data Pump

Easy data import and export to Google Sheets

Use the import/export wizards to exchange data between SQL databases and Google Spreadsheets. Take full advantage of multiple customization options. Create templates for recurring tasks.

Learn more...

Data Export

SQL export to 14 commonly used formats

With Data Pump for SQL Server, you can export database data in the following formats:

HTML
Text
MS Excel
MS Excel 2007
MS Access
RTF
PDF

JSON
XML
CSV
ODBC
DBF
SQL

Data Export Wizard helps perform export in just a few clicks.

Select data to be exported

When performing export tasks with Data Pump you can select what you want to be exported:

SQL Server connection
Database
Table(s)
View(s)

The tool makes it possible to transfer data across different servers and IDEs.

Data Pump for SQL Server - Export Source

Output settings

You can configure output settings for exported data:

Export data to separate files and specify the required folder
Export data to a single file, specify its name and the required path
Append a timestamp to the file name
Check the exported files preview

Data Pump for SQL Server - Export Output Settings

Customizable view

With the Data Pump tool, you can set table grid options for exported data.

You can configure:

Header text color and background
The width and color of borders
The text color and background of rows

For convenience, you can make even and odd rows look different.

Data Pump for SQL Server - Data export options

Configurable data format

By setting data format representation, you can encourage and deliver unified data standards within your company.

You can also assign data types for columns:

Integer
Date
Time
String
HexString
Float
Currency
DateTime
Boolean

Exporting rows

It is not necessary to export the whole table. You can select to export all rows, export the selected rows only, or export the range of rows.

The selective export feature mitigates data transfer and greatly saves time.

Data Pump for SQL Server - Exporting rows

Errors handling

You can specify errors processing behavior and logging options:

Prompt a user for an action
Ignore all errors
Abort at the first error

You can also select to create a log file with a report and set a path to it.

Data Pump for SQL Server - Errors handling

Saving export templates

Data Pump for SQL Server allows you to save export options templates for recurring export scenarios.

Waste no time configuring options over and over again: use templates to apply options to any number of export operations.

Template files can be applied to schedule automated data export via the command-line interface (CLI).

Data Pump for SQL Server - Export templates

Export from the command line

Performing routine export becomes significantly easier and more convenient with the command line support.

Use the command-line interface or PorwerShell to automate data export tasks
Save data export command as a command-line execution file (.bat) and run it whenever you need
Schedule a batch file execution via the Windows Scheduler to simplify your database maintenance operations

Data Pump for SQL Server - Export from the command line

Data Import

Data Pump for SQL Server - SQL Import to 9 formats

SQL import from 9 widely used formats

Data Pump for SQL Server allows you to import database data from the following formats:

Text
MS Excel
MS Excel 2007
MS Access
XML

JSON
CSV
ODBC
DBF
Google Sheets

Data Import Wizard helps perform import tasks in just a few clicks.

Data Pump for SQL Server - Import destination

Import to a new table

When performing a data import operation with Data Pump, you can select to import to a different SQL Server connection, database, or schema.

You can also import data to a new or existing table.

The tool makes it possible to transfer data between different databases and servers.

Data Pump for SQL Server - Data import options

Customizable import options

With Data Pump, you can set import options according to your needs.

Custom settings depend on the selected data import format.

For convenience, you can set a range of rows of columns to be imported.

Data Pump for SQL Server - Import data formats

Configurable data format

Data Pump can help introduce and sustain data standards within your organization.

With the tool, you can adjust:

Null string
Thousand separator
Decimal separator
Boolean
Date and time format

You can set options for each column separately.

Mapping options

Column mapping allows you to configure how your records should be stored in the target destination for maximum performance and efficiency.

If you are importing data into a new table, Data Pump will automatically create and map all the columns. If you are importing data into an existing table, the columns with the same names will already be mapped, the rest you can map manually.

Data import modes

You can choose a data import mode according to the needs of your project:

Append
Update
Append\Update
Delete
Repopulate

You can also select to import data in a single transaction and/or use a bulk insert.

Data Pump for SQL Server - Import Output

Data import output

With Data Pump for SQL Server, you can select options to manage the data import script output:

Open the script in the internal editor
Save the script to a file
Import data directly to the database

The tool also allows to automatically add timestamp to the file name and select a folder to save the file to.

Import errors handling

You can customize errors handling behavior and logging options according to the needs of your project.

Managing errors processing helps significantly save database development, administration, and maintenance time.

Saving import templates

Data Pump allows saving your import options as a template in order to speed up recurring data import. You can then re-use the template as many times as you want.

It is also possible to share templates with the team to save time and ensure data standardization.

Template files can be applied to schedule automated data import via the command-line interface (CLI).

Data Pump for SQL Server - Command line Import

Import from the command line

The tool allows importing a specified file or table via the command line. It is also possible to perform import operations using templates.

With Data Pump, you can:

Override a connection specified in the template
Create a new table during import
Import data with settings specified in a template
Specify a file with the data you want to import
Specify a target table
Specify a table or view to import the data from
Specify the application behavior when an error is encountered

Get started with dbForge Data Pump at no cost

Download a FREE 30-day trial and start saving time spent on your routine database export and import today.

Download for free

Buy multiple licenses with a substantial discount

We provide flexible purchase options, including bulk discounts, to meet the budget of each and every customer.

Purchase now

Need a hand?

If you need any help or have questions about Devart tools or purchasing options, do not hesitate to get in touch with us.

Data Pump as part of DevOps Automation

Use Data Pump along with dbForge DevOps Automation for SQL Server to extend the DevOps approach to SQL Server databases. The solution makes it easy to integrate SQL Server database into the DevOps process without compromising quality, performance, or reliability.

Explore

Export and Import Data in SQL Server

Supported File Formats

and more...

Learn how to migrate data between databases using Data Pump

Meet the killer feature of dbForge Data Pump

Easy data import and export to Google Sheets

SQL export to 14 commonly used formats

Select data to be exported

Output settings

Customizable view

Configurable data format

Exporting rows

Errors handling

Saving export templates

Export from the command line

SQL import from 9 widely used formats

Import to a new table

Customizable import options

Configurable data format

Mapping options

Data import modes

Data import output

Import errors handling

Saving import templates

Import from the command line

dbForge SQL Tools

Get started with dbForge Data Pump at no cost

Buy multiple licenses with a substantial discount

Need a hand?

Data Pump as part of DevOps Automation