Import and Export SQL Data

dbForge Data Pump is an SSMS 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 (Text, MS Excel, XML, CSV, JSON etc.) and includes a number of advanced options and templates for recurring scenarios.

Data Import

Import from 9 widely-used data formats (Text, MS Excel, MS Excel 2007, MS Access, XML, CSV, ODBC, DBF (Foxpro, dBase III, dBase IV, dBase 7), JSON)

Templates to save import settings for each data format

Import to existing or new tables

Preview of imported data in Data Import Wizard

Selecting data formats and column settings for imported data

Selecting import modes: Append, Update, Append/Update, Delete, Repopulate

Setting up errors handling

Generating a log file with import session details

Data Export

Export to 13 commonly used data formats (HTML, Text, MS Excel, MS Excel 2007, MS Access, RTF, PDF, XML, CSV, DBF, ODBC, DBF (Foxpro, dBase III, dBase IV, dBase 7), SQL, JSON)

Export from tables, views, or queries

Templates to save export settings for each data format

Selecting columns and a range of rows for export in Data Export Wizard

Setting up fonts and colors for graphical formats

Selecting formatting for text formats

Setting up data formats for exported data

Page setup for RTF, PDF, MS Excel formats

Unicode support