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.

Supported File Formats









and more!

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

dbForge Developer Bundle for SQL Server

Data Pump is a part of dbForge Developer Bundle for SQL Server - an ultimate kit of fourteen database development and management tools for SSMS. Purchasing the single kit will save you 50% of the cost of each tool as compared to purchasing them individually.


Developer Bundle Save up to 25

Discount Programs

Get More Solutions for SQL Server