Data Import and Export Tools for SQL Server

With dbForge Studio for SQL Server, you can easily migrate SQL data to and from the most widely-used data formats. Data Import/Export tools allow you to customize and manage the whole process, create templates for future use, specify error processing options as well as write reports to a log file. The integrated data import/export tools will greatly save your time, as well as make the data export/import process more comfortable, efficient and effortless.

Supported Data Export/Import Formats

HTML Format
TXT Format
XSLX Format
MDB Format
RTF Format
PDF Format
JSON Format
XML Format
CSV Format
ODBC Format
DBF Format
SQL Format

Data Import

With dbForge Studio for SQL Server, you can create import templates for a later data import via the wizard or the command line interface, as well as adjust the import process according to your requirements.

Data Import Wizard features:

  • Import from 9 widely-used data formats: Text, MS Excel, MS Excel 2007, MS Access, XML, CSV, DBF (Foxpro, dBase III, dBase IV, dBase 7), ODBC, JSON
  • Templates to save import settings for each data format
  • Import to existing or new tables
  • Preview of imported data
  • 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 Import Wizard

Data Export

Use the export tool's options for exporting data to the most popular formats and adjusting the export process according to your needs.

Data Export Wizard features:

  • Export to 13 commonly used data formats: HTML, Text, MS Excel, MS Excel 2007, MS Access, RTF, PDF, XML, CSV, JSON, ODBC, DBF (Foxpro, dBase III, dBase IV, dBase 7), SQL
  • Export from tables, views, or queries
  • Templates to save export settings for each data format
  • Selecting columns and a range of rows for export
  • 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
Data Export Wizard