dbForge Studio for SQL Server lets you export data from tables, views, and query results to migrate data across different servers.
The following table describes the file formats supported in dbForge Studio for SQL Server.
| File format | Extension | Description |
|---|---|---|
| HTML | .html, .htm | A markup language used for creating web pages. |
| Text (TXT) | .txt | A plain text format. |
| MS Excel (XLS) | .xls | A Microsoft Excel binary spreadsheet format. |
| MS Excel 2007+ (XLSX) | .xlsx | A spreadsheet format for Excel 2007 and later. |
| Google Sheets | N/A (cloud-based) | A cloud-based spreadsheet format used for opening, editing, and sharing data online in Google Sheets. |
| MS Access (MDB) | .mdb, .accdb | A database format used by Microsoft DBMS Access (2003, 2007+). |
| RTF | .rtf | A cross-platform format used for exchanging text files. |
| A file format used for displaying and sharing documents independent of the software, devices, and operating systems used. Only data encoded in the Latin character set can be exported. | ||
| JSON | .json | An open human-readable text format for transmitting data objects using attribute-value pairs. |
| XML | .xml | A markup language and file format for storing and transmitting data. |
| CSV | .csv | A text-based format for storing tabular data with comma-separated values. |
| ODBC | N/A | A standard API for accessing data from various database management systems. |
| DBF | .dbf (related extensions: .dbt, .fpt) | A database file format used by FoxPro, dBase III, dBase IV, and dBase 7. The ANSI character set is used during export. |
| SQL | .sql | A file format containing a SQL script for accessing and managing data in databases. |
Note
The Express edition of dbForge Studio supports export only to HTML, CSV, and ODBC formats.
dbForge Studio provides the Data Export wizard, which lets you configure data export settings such as selecting columns and specifying their data formats, choosing rows to export, and setting table grid options.
After configuring the settings, you can save them to a template file (.det) for reuse in future export operations, for example, when scheduling data exports from the command line.
dbForge Studio provides the command-line wizard that enables you to configure automated routine jobs. Save export settings to a command-line execution file (.bat) and use it to automate or schedule data export tasks from the command line or PowerShell.
Watch this tutorial to learn more about how to export and import data in SQL Server.