dbForge Data Pump is an SSMS 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 (Text, MS Excel, XML, CSV, JSON etc.) and includes a number of advanced options and templates for recurring scenarios. Supports SQL Server 2022.
Features
Data Export:
- Exporting rows
- Errors handling
- Saving export templates
- Export from the command line
- SQL export to 14 commonly used format
- Selected data to be exported
- Output settings
- Customizable view
- Configurable data format
Data import:
- Data import output
- Import errors handling
- Saving import templates
- Import from the command line
- SQL import from 9 widely used format
- Import to a new table
- Customizable import option
- Configurable data format
- Mapping options
- Data import modes
Data Import