Database synchronization software provides secure and advance database conversion services to migrate database records from MySQL to MS SQL along with all table fields, attributes, indexes, data types, keys, rows, columns or triggers.
Pros: MySQL to MS SQL conversion software provides simple and easy wizard style interface to migrate MySQL server to MSSQL database with all keys, schema, data types, values, indexes, constraints etc. It converts whole database or specific table records from MySQL to the MS SQLServer without any data loss. Database integrity and Unicode architecture is preserved while converting. Converter manages support for MySQL features like foreign unique keys, default null values, triggers etc. All types of data whether it is numeric, text strings, date & time etc. All properties like keys, values, data types, triggers, attributes, stored procedures, view, relationships, normalization etc are supported too. While converting one can create a completely new database in SQL Server or at option may merge into an existing database. The utility works over a distributed architecture also. So the MySQL database or the SQLServer database need not be in the same machine and they can connect via Windows authentication or SQLServer authentication. Once connections are set up, by specifying the user name/password for both the databases, the conversion is done through a wizard-like interface. Connections set up are secure and reliable on all the versions of Window. These include 98, 2000, 2003 server, ME, NT, XP and versions of windows Vista. One picks the source databases to be converted into the target database on the SQLServer and the conversion is done automatically.
Cons: Users need to be assured of data integrity when real life complex schema are in use in the databases. You may need to benchmark jobs that are part of your day to day use.
Overall: Simple wizard like interface makes this easy to use, all that needs to be done are selecting the source and the destination databases/tables. This is a very good 3 star rated package.