Über dbForge Data Pump

Exportieren und importieren Sie SQL-Daten in gängigen Formaten.

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

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

Data Import

  • Import from 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 imported data in Data Import Wizard.
  • Select data formats and column settings for imported data.
  • Select import modes: Append, Update, Append/Update, Delete, Repopulate.
  • Set up errors handling.
  • Generate a log file with import session details.

Data Export

  • Export to commonly used data formats (HTML, Text, MS Excel, MS Excel 2007, MS Access, RTF, PDF, XML, CSV, ODBC, DBF (Foxpro, dBase III, dBase IV, dBase 7), SQL, JSON).
  • Export from tables, or views.
  • Templates to save export settings for each data format.
  • Select columns and a range of rows for export in Data Export Wizard.
  • Set up fonts and colors for graphical formats.
  • Select formatting for text formats.
  • Set up data formats for exported data.
  • Page setup for RTF, PDF, MS Excel formats.
  • Unicode support.