Previous Next

Data Import and Export Tools for SQL Server

With dbForge Studio for SQL Server you can easily migrate SQL data to a new database after an upgrade or creating a backup. With the help of SQL export tool you can easily export SQL table data to different file formats. Once the table data was exported, you can import it any time using SQL import tool.

Import and export tools employ such features as:

  • Data import from 8 formats (CSV, Excel, XML, etc.)
  • Data export to 12 formats (Text, XML, CSV, etc.)
  • Multiple data import and export customization options
  • User friendly data export and import wizards

Whenever you require an SQL Server data import and export tool, give it a try with dbForge Studio for SQL Server. Export data from tables and views and insert exported data into tables using the integrated data import/export tools.

Data Import

Use dbForge Studio to import data from 8 widely-used formats, adjust the import process according to your requirements.

A user friendly wizard will guide you through the import process, with each step represented on a separate page. Create import templates for a later data import via the wizard or the command line interface.

Data Import Wizard features:

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

Use the export tool's options for exporting data to 12 conventional formats and adjusting the export process according to your needs:

  • Convenient step-by-step wizard
  • Command line interface
  • Table or view selection
  • Random column/range selection
  • Formatting options
  • Export templates

Data Export Wizard features:

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