Export and import data
Last modified: July 22, 2025
This section provides comprehensive instructions for exporting and importing data using built-in tools and command-line options. It includes supported formats such as CSV, JSON, XML, DBF, XLS, and MDB, along with features like applying WHERE conditions, migrating data from other servers, and importing to new tables. Topics also cover the use of templates, additional command-line arguments, and exit codes for automation and troubleshooting. The content is designed to support efficient and consistent data transfer across various scenarios.
In this section
- Data export overview
- Data export
- Save and use export templates
- Export data from the command line
- Additional /dataexport arguments
- Exit codes used in the command line for /dataexport
- Data import overview
- MDB import
- CSV import
- DBF import
- XLS import
- Text import
- JSON import
- XML import
- Export data based on a WHERE condition
- Migrate data from other servers
- Import data to a new table
- Save and use import templates
- Import data from the command line
- Additional /dataimport arguments
- Exit codes used in the command line for /dataimport
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.