MS SQL Migration Toolkit

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.

Features

• All versions of Microsoft SQL Server are supported (including Azure SQL)
• Converts table structures and data with all necessary attributes
• Option to synchronize destination database with the source data
• Converts indexes, foreign keys and queries (views)
• Option to filter data using SELECT-queries
• Stores conversion settings into profile
• Command line support
• Easy-to-use wizard-style interface
• Quick Launch
• Full install/uninstall support
• The product can be customized according to customer requirements
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert stored procedures and triggers
• Demo version converts only 50 records per table
• Demo version does not convert queries/views and foreign keys

Requirements

• Supported OS: Windows XP(SP2 or SP3)/2003/Vista/Server 2008/7/8/10, Linux with WINE
• Microsoft SQL environment for MS SQL related tools (server or client components of MS SQL must be installed on the same machine where you run the program from)
• Necessary privileges to write into the destination database

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.

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!