Export and Import Data
in SQL Server
Data Pump is a SQL Server Management Studio add-in for filling SQL databases with external source data and migrating data between systems. The tool supports import and export from 10+ widely used data formats (Excel, CSV, XML, JSON, Text, MS Access, etc.) and includes a number of advanced options and templates for recurring scenarios.
Data Pump for SQL Server is a highly customizable solution aiming to facilitate data import and export and thus boost your productivity and accelerate your results.
- Import data from 10 most popular data formats
- Export data to 14 widely used data formats
- Migrate data from third-party databases to SQL Server
- Repopulate or append data to database tables
- Dump table data to one or multiple SQL files
- Use templates for recurring scenarios
- Use CLI to schedule and automate data export and import tasks