DBSync for MS SQL & MySQL

DBSync for MS SQL & MySQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:

• MS SQL to MySQL
• MS SQL to MS SQL
• MySQL to MS SQL
• MySQL to MySQL

Synchronize and convert databases from MS SQL to MySQL or from MySQL to MS SQL rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBSync for MS SQL & MySQL is also applicable for MySQL database synchronization and migration to another MySQL database or even to another MySQL server. Moreover, DBSync for MS SQL & MySQL is quite well for MS SQL database synchronizing and migration to another MS SQL database or to another MS SQL Server.

As you know the conversion speed depends on different things: the source file size, the computer performance, the output settings and so on. Now you don't need to search any tips to speed up the conversion. To increase conversion speed we improved our engine for large databases, with approximately 500 thousand records and more. Now they can be converted in 30-40 min for MS SQL and in 3-5 min for MySQL .

Keep all your databases up-to-date with trigger-based instant synchronization method. Using our pre-created triggers you can notice that the synchronization speed is faster in times. Read more about this feature here.

Features
• Microsoft SQL Server Express 2005/2008 and Microsoft SQL Server 2000/2005/2008 support
• Insert-synchronization, Update-synchronization and Drop-synchronization available;
• Database objects (tables, fields, indexes and foreign keys) remapping;
• Interactive (GUI) mode / command line mode
• Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
• Automation of the conversion and synchronization process with task scheduler;
• Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL;
• High speed data conversion and synchronization. DBSync for MS SQL & MySQL speed noticeably exceeds average showing in this category as the program works with direct access to MS Server and to MySQL Server not through ODBC like other similar converters;
• Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support;
• Primary keys and Indexes support;
• Foreign keys (relations) support;
• MS SQL schemes support;
• Advanced customization options:
- partial selection for database objects to be converted.
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage.
• Sessions support - all your settings can be saved and restored later;
• Data array support.
• `ENUM` and `SET` MySQL database types support;
• `BLOB` conversion support;
• Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
• Skins support;
• Multilanguage Support (English/French/Russian);
• 1-year free upgrades.

Requirements

• Necessary privileges to write into database on the target MS SQL / MySQL server
• MDAC 2.8
• MySQL 4.x/5.x
• MS SQL 2000/2005/2008/2012/Express
• Microsoft Visual C++ 2008 x86 Redistributable package