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.
What is new in this release:
SQL Server 2016 Service Pack 1 (SP1) new syntax support. SQL Server 2017 new syntax support. The latest SQL Server Management Studio v17.2 integration support. Azure SQL Data Warehouse support. Support for the Command Line Interface.
What is new in version 1.2:
* Dramatically improved data import performance * Export/import of JSON data * Redesigned export/import of XML data * Preview of the generated UPDATE script in the wizard * Detection of column types when importing data from the Excel format
What is new in version 1.1.63:
Version 1.1.63: Support for SQL Server 2016; Integration into SSMS 2016.
.NET Framework 4.5