dbForge Data Pump for SQL Server

SSMS add-in for filling SQL databases with external source data and migrating data between systems. The tool supports 10+ widely used data formats and includes a number of advanced options and templates for recurring scenarios
Key Features
Data Import:
- 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
- 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