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

Discount Programs

Send us a link to your MVP profile and get a free license for any SQL Server product from Devart range!

MS MVP

Get significant discounts, and even free licenses for spreading a word about dbForge Data Pump.

Devart High Five Program for dbForge Data Pump

Get 50% OFF for switching to dbForge Data Pump from competing tools!

SQL Data Pump Competitive Upgrade

dbForge Developer Bundle for SQL Server

An ultimate kit of 13 database development and management tools in one package. Grab the full power of dbForge Developer Bundle for SQL Server and benefit from a sensational discount in comparison with buying tools separately.

Developer Bundle Save up to 25

More SQL Server Development Tools