Description

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

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

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).

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.

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.

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.

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.

Additional Information