convert access to ms sql, oracle to ms sql, ms sql to mysql, excel to ms sql, ms sql to access, mysql to ms sql, ms sql to excel, any data source, miscrosoft sql server, free download, shareware
FAQ  |  Site map  |  Contact Us
About Us How to Buy Products Discounts Migration Service Support Become a Partner Articles

MS SQL Migration Toolkit


Latest version 5.3 released 11/21/2016

MS SQL Migration Toolkit is a collection of database migration tools to convert any data source to Microsoft SQL Server or SQL Azure and vice versa. It is easy, fast and accurate. MS SQL Migration Toolkit includes the following tools:
Access-to-MSSQL a program to migrate MS Access database to SQL Server or SQL Azure. All versions of Microsoft Access and MS SQL (including Azure SQL) are supported. The program can process MS Access databases protected with password or user-level security. MSSQL Migration Toolkit
DBF-to-MSSQL a program to convert FoxPro/Clipper/DBase files into MS SQL database. It supports all formats of DBF and MEMO files.
Excel-to-MSSQL a program to convert Microsoft Excel spreadsheet into MS SQL or SQL Azure database. All versions of MS Excel are supported.
MSSQL-to-Access a program to convert SQL Server or SQL Azure databases into Microsoft Access format. MS Access 97/2000/2010 formats are supported.
MSSQL-to-Excel a program to export SQL Server or SQL Azure databases into Microsoft Excel spreadsheets. It provides feature to filter data via SELECT-queries.
MSSQL-to-MySQL a program to migrate MS SQL or SQL Azure databases to MySQL server. All versions of MySQL servers running on Linux, Unix and Windows platforms are supported. Option to export the source data into MySQL script files.
MSSQL-to-Oracle a program to migrate SQL Server or Azure SQL database to Oracle server. It support all versions of 32- and 64- bit Oracle running on Linux, Unix and Windows platforms.
MSSQL-to-PostgreSQL a program to migrate Misrosoft SQL databases to Postgres server. It supports all variations of MS SQL and PostgreSQL including Azure SQL and Heroku.
MySQL-to-MSSQL a program to migrate MySQL databases to SQL Server or Azure SQL. All versions of MySQL running on Linux, Unix and Windows platforms are supported.
Oracle-to-MSSQL a program to migrate Oracle databases to SQL Server or Azure SQL. It support all versions of 32- and 64- bit Oracle running on Linux, Unix and Windows platforms.
Postgres-to-MSSQL a program to migrate Postgres databases to Misrosoft SQL or Azure SQL.

Download trial version of MS SQL Migration Toolkit

Features

  • Converts table definitions, data, indexes, foreign keys and queries (views)
  • Option to synchronize destination database with the source data
  • Stores conversion settings into profile
  • Option to filter data using SELECT-queries
  • Command line support
  • Easy-to-use wizard-style interface
  • Quick Launch
  • Full install/uninstall support
  • 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

  • Microsoft SQL environment (server or client components of MS SQL must be installed)
  • PostgreSQL environment for related tools (server or client components of PostgreSQL must be installed)
  • Necessary privileges to write into the destination database
  • Supported OS: Windows XP(SP2 or SP3)/2003/Vista/Server 2008/7/8/10

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

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.

 

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