The easiest way to export and import data in SQL Server

dbForge Data Pump is a SQL Server Management Studio add-in that makes it very easy to populate your databases with external source data and migrate data between systems. With its help, you can perform import and export operations using up to 14 most popular data formats. What's more, you can enhance these operations with advanced options, templates for recurring scenarios, and CLI-powered automation.

  • Import data from 10 file formats
  • Export data to 14 file formats
  • Migrate data from other databases to SQL Server
  • Repopulate or append data to database tables
  • Dump table data to one or multiple files
  • Create reusable templates for recurring operations
  • Automate migration from the command line

Cross-server data exchange: One tool for both directions

Get a free trial
Data transfer

Transfer data to other servers

It's never been easier to export data with a few clicks—then configure, map, and push it to your destination server.

Data loading

Load data from other servers

Likewise, you can easily load external data into your target database. Flexible settings, templates, and automation options will further enhance your experience.

Why choose Data Pump

Data migration in multiple formats

After you select to export or import data via dbForge Data Pump, you can select the format that you would like to use. There are 14 formats for export and 10 for import. The complete list of available formats is as follows:

  • TXT
  • XLS
  • XLSX
  • HTML
  • MDB
  • RTF
  • PDF
  • JSON
  • XML
  • CSV
  • ODBC
  • DBF
  • SQL
  • Google Sheets
Get a free trial

Customizable options

For each format, Data Pump offers a rich selection of settings to make your import and export operations most flexible. These settings can be configured step by step on each page of the wizard. Note that the actual number and content of pages may vary according to the selected format and operation (import or export).

Get a free trial

Smart mapping

When it comes to import, you will definitely be pleased by the convenience of column mapping. It allows you to configure how your records should be stored in the target destination for maximum performance and efficiency.

Take note that 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 be mapped automatically. Then, you will be able to map the remaining columns manually.

Get a free trial

Error handling

Whenever Data Pump encounters an error during an import or export operation, it can act in three possible ways: prompt you for an action, ignore all errors, or abort the operation at the first encountered error.

You can pick the preferred option on the corresponding page of the wizard. Additionally, you can select an option to create a log file with a report and set a path to it.

Get a free trial

Templates for recurring operations

Once you configure your import or export settings in Data Pump, you can save them to a template that can be further reused at any moment.

It's a great time-saver for recurring operations; you can apply templates to any number of import and export operations.

You can also use template files when setting up automated import and export of your data from the command line.

Get a free trial

Command-line automation

Routine import and export operations become far easier and more convenient with the command-line automation features delivered by dbForge Data Pump.

Once you configure your settings in the Data Import or Data Export wizard, you can auto-generate a script based on these settings. Alternatively, you can save a template file with your settings and write the path to this template file in your script.

Next, your script can be either run immediately or saved to a command-line execution file (.bat) that can be executed whenever you need it.

Finally, you can schedule your .bat file for regular execution via Windows Task Scheduler in order to fully automate your import and export operations.

Get a free trial

Supported file formats

Data Pump performs data import and export in a total of 14 formats. For each of them, you get a set of format-specific settings and reusable templates for regular operations.

JSON
JSON
Excel
MS Excel
CSV
CSV
XML
XML
DBF
DBF
ODBC
ODBC
HTML
HTML
SQL
SQL

Editions and prices

dbForge Data Pump

Starts from

$169.95
per year
Try the tool

Key features:

  • Wizard-aided import from 10 file formats
  • Wizard-aided export to 14 file formats
  • Custom templates for recurring import and export operations
  • Preview of imported data
  • Automation from the command line
Save 60% with the bundle

dbForge SQL Tools

Starts from

$429.95
per year
Try the complete bundle

Includes 15 tools:

Trusted by thousands of data-driven companies
Barkley
Arconic
Polaris
Jabil
HP
Lam
Microsoft
Trusted by thousands of data-driven companies
Barkley Arconic Polaris Jabil HP Lam Microsoft

What our customers say

1.5x
quicker data comparison and sync routines
2x
faster SQL coding
"We are able to deliver code of significantly better quality, and better tested in a shorter time than was possible before our investment in Devart tools... Our customers get access to more robust applications, against more realistic data."
Andrew Richards, Managing Director at The IT Service
Read the full story
Success story from our customer
+2x
faster performance
150%
productivity improvement
"Easy, repeatable. Just works. We just wanted the easy way to do things. You've provided us with a reliable tool that we depend on daily."
Steve Palmer, Consultant at GoodSoftware.com, LLC
Read the full story
Success story from our customer
SoftwareSuggest - Momentum Leader Winter 2025
G2 - Users Love Us
SourceForge - Customers Love Us

Ready to get started?

Get started

Get your 30-day trial

Give dbForge Data Pump a go during a FREE 30-day trial and see all of its versatile import and export capabilities in action.

Get a free trial now
Get bulk discounts

Enjoy bulk discounts

We offer flexible purchasing options to meet your budget. Also, if you need multiple licenses, you will get a bulk discount.

Discover now
Need a hand?

Need a hand?

If you need any help or have questions about our tools or purchasing options, feel free to get in touch with our team.

Contact us

FAQ

What is dbForge Data Pump used for?

dbForge Data Pump is used to migrate data between databases quickly and effectively. With its help, you can import and export SQL Server data using up to 14 formats, load external source data to SQL Server databases, create custom templates for SQL Server import and export operations, and automate them from the command line.

Can I export SQL Server data to JSON automatically?

Yes. JSON is one of the 14 formats supported by dbForge Data Pump. You can configure your export settings with a handy wizard and save them to a command-line execution file (.bat). After that, you can either run this file at any moment or schedule it for regular execution via Windows Task Scheduler to export your data to JSON automatically.

How do I schedule regular SQL data exports?

To schedule regular SQL data exports via Data Pump:

  1. Configure export settings in the Data Export wizard.
  2. In the lower left corner of the wizard, click Save Template > Save Command Line. Data Pump will auto-generate a reusable CLI script with your configured export settings.
  3. Save your configured export settings to a .bat file.
  4. Schedule this file for regular execution via Windows Task Scheduler or a similar tool.

The same goes for data import operations.

How do I handle import errors in SQL Server efficiently?

You can configure the error handling behavior on the corresponding page of the Data Import wizard in dbForge Data Pump. It can be set to either prompt you for an action, ignore all errors, or abort the operation upon encountering an error.

Additionally, you can select an option to create a log file for the operation.

Can I use saved templates in dbForge via CLI?

Yes. You can indicate the path to a saved import/export template in your CLI script. Afterwards, you can run this script from the command line or schedule it for regular execution.

How many file formats does dbForge Data Pump support?

dbForge Data Pump supports 14 formats in total: TXT, XLS, XLSX, HTML, MDB, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL, and Google Sheets.

Is dbForge Data Pump compatible with SSMS?

Yes. dbForge Data Pump is an add-in for SSMS. What's more, regular updates make it continuously compatible with all relevant SSMS versions, up to the latest one.

How do I map columns during data import in dbForge?

The Data Import wizard of dbForge Data Pump has a special page called Mapping, where you can map the content of your imported file to table columns. There, you also have a convenient section where you can preview the mapped content.