From:       To:      

MS SQL Migration Toolkit

[Features]  [Limitations]  [Release Notes]  [Download]  [Buy]
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. MSSQL Migration Toolkit
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.

Download trial version of MS SQL Migration Toolkit

Features

Limitations

Requirements

Quick Launch

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.

Synchronization

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		a.white@corporation.com
    3	Phil		Johnson		p.johnson@gmail.com

In the destination database:

    1	John		Smith		j.smith@msn.com
    2	Andrew		White		a.white@yahoo.com

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		j.smith@msn.com
    2	Andrew		White		a.white@corporation.com
    3	Phil		Johnson		p.johnson@gmail.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.

Download trial version of MS SQL Migration Toolkit

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.

Ordering

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 BUY NOW link. To learn about alternative payment options please visit our Ordering Page.

Basic Business Enterprise
Max.users 1 5 unlimited
Subscription for updates no 1 year lifetime
Support priority low medium high
Command line support no yes yes
Price $149 $299 $499
BUY NOW! BUY NOW! BUY NOW!