MS SQL Migration Toolkit
Latest version 7.1 released 03/15/2021
MS SQL Migration Toolkit is a software pack to convert any data source to Microsoft SQL Server or Azure SQL and vice versa. The product has high performance because it does not use ODBC or any other middleware software. Command line support allows to script, automate and schedule the conversion. MS SQL Migration Toolkit includes the following tools:
|Access-to-MSSQL||migrates Microsoft Access databases to SQL Server or Azure SQL. All versions of Microsoft Access (including MS Access 2016) are supported. The program can process MS Access databases protected with password or user-level security.|
|DB2-to-MSSQL||migrates IBM DB2 databases to SQL Server or Azure SQL. All versions of IBM DB2 are supported.|
|DBF-to-MSSQL||migrates DBase/FoxPro/Clipper (*.dbf) databases to MS SQL server or Azure SQL. All formats of DBF files and MEMO files are supported.|
|Excel-to-MSSQL||converts Microsoft Excel spreadsheet into MS SQL or Azure SQL database. All versions of MS Excel are supported (including MS Excel 2016).|
|MSSQL-to-Access||converts SQL Server or Azure SQL databases into Microsoft Access format. MS Access 97/2000/2010 formats are supported.|
|MSSQL-to-Excel||converts SQL Server or Azure SQL databases into Microsoft Excel spreadsheets. Option to filter data using SELECT-queries.|
|MSSQL-to-MySQL||migrates SQL Server or Azure SQL databases to MySQL server. All versions of Linux/Unix and Windows MySQL servers are supported. The program can also export data into MySQL dump files.|
|MSSQL-to-Oracle||migrates MS SQL or Azure SQL databases to Oracle server. All versions of 32- and 64- bit Windows and Linux/Unix Oracle servers are supported.|
|MSSQL-to-PostgreSQL||migrates Microsoft SQL or Azure SQL databases to PostgreSQL server.|
|MySQL-to-MSSQL||migrates MySQL databases to SQL Server or Azure SQL. All versions of Linux/Unix and Windows MySQL are supported.|
|Oracle-to-MSSQL||migrates Oracle databases to SQL Server or Azure SQL.|
|PostgreSQL-to-MSSQL||migrates PostgreSQL databases to Microsoft SQL or Azure SQL server.|
|SQLite-to-MSSQL||migrates SQLite databases to Microsoft SQL or Azure SQL server.|
Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description file with left mouse button. It will launch the appropriate conversion process loading necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.
MS SQL Migration Toolkit implements synchronization as combination of insert records that are missing in the destination table and update existing records with the source data. For synchronization purpose source and destination tables must have identical structures and have primary key or unique index defined. Assume both source and destination databases have table "People" defined as below:
People( ID INT NOT NULL, FName VARCHAR2(50) / VARCHAR(50), LName VARCHAR2(50) / VARCHAR(50), EMail VARCHAR2(50) / VARCHAR(50), Primary Key (ID) );
This table has the following contents in the source database:
2 Andrew White email@example.com 3 Phil Johnson firstname.lastname@example.org
In the destination database:
1 John Smith email@example.com 2 Andrew White firstname.lastname@example.org
After migrating data in "Synchronize" mode the source table is kept untouched and the destination table is modified as follows (pay attention to the second record):
1 John Smith email@example.com 2 Andrew White firstname.lastname@example.org 3 Phil Johnson email@example.com
Try before you buy
Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.
Subscription for updates
Business and Enterprise licenses of MS SQL Migration Toolkit are supplied with subscription for updates (see the table below). It means that you will receive new versions of the software included in MS SQL Migration Toolkit for free within the subscription period. Also you will get all new utilities for migration from/to MS SQL that will be released during that timeframe.
Intelligent Converters software is distributed through downloading from our server only. For online credit card purchasing select the desired software package in the table below and click the corresponding ORDER NOW link. To learn about alternative payment options please visit our Ordering Page.
|Subscription for updates||no||1 year||lifetime|
|Command line support||no||yes||yes|
|BUY NOW!||BUY NOW!||BUY NOW!|