MS SQL Migration Toolkit

[Features]  [Limitations]  [Download]  [Buy]
Latest version 5.1 released 03/20/2016

MS SQL Migration Toolkit is a software pack to convert any data source to Microsoft SQL Server or SQL Azure 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 SQL Azure. All versions of Microsoft Access (including MS Access 2012) are supported. The program can process MS Access databases protected with password or user-level security.
DBF-to-MSSQL migrates DBase/FoxPro/Clipper (*.dbf) databases to MS SQL server or SQL Azure. All formats of DBF files and MEMO files are supported.
Excel-to-MSSQL converts Microsoft Excel spreadsheet into MS SQL or SQL Azure database. All versions of MS Excel are supported (including MS Excel 2012).
MSSQL-to-Access converts SQL Server or SQL Azure databases into Microsoft Access format. MS Access 97/2000/2010 formats are supported.
MSSQL-to-Excel converts SQL Server or SQL Azure databases into Microsoft Excel spreadsheets. Option to filter data using SELECT-queries.
MSSQL-to-MySQL migrates SQL Server or SQL Azure 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 SQL Azure databases to Oracle server. All versions of 32- and 64- bit Windows and Linux/Unix Oracle servers are supported.
MSSQL-to-PostgreSQL migrates Misrosoft SQL or SQL Azure databases to Postgres server. 
MySQL-to-MSSQL migrates MySQL databases to SQL Server or SQL Azure. All versions of Linux/Unix and Windows MySQL are supported.
Oracle-to-MSSQL migrates Oracle databases to SQL Server or SQL Azure.
Postgres-to-MSSQL migrates Postgres databases to Misrosoft SQL or SQL Azure server. 
MSSQL Migration Toolkit

Download trial version of MS SQL Migration Toolkit

Features

Limitations

 

Worked as a Charm!
Phillip van Niekerk (about MSSQL-to-Excel)
http://www.phillwebdesign.com

Quick Lauch

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 cell marked red):

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 five 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

Free subscription for updates

As every Intelligent Converters product, MS SQL Migration Toolkit is supplied with one year subscription for updates. It means that you will receive new versions of the software included in MS SQL Migration Toolkit for free within one year. Moreover, you will receive all new utilities for migration from/to MS SQL that will be released during your subscription period.

We love the product so far, seriously. Lifesaver.
Joel Hughes (about MSSQL-to-MySQL)

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

 

MS SQL Migration Toolkit (Single-User License)
allows clients to install the software product on exactly one (1)
computer system. Single-User License does NOT allow to
make use of the software through a corporate network.
$99 ORDER NOW
MS SQL Migration Toolkit
10 user licenses
$149 ORDER NOW
MS SQL Migration Toolkit (Corporate License)
allows a single company to install the software product
on an unlimited number of machines within that corporation.
All machines must be owned, leased, or used for the purpose
of the purchasing company.
$199 ORDER NOW