MSSQL2MySQL Sync description
MSSQL2MySQL Sync - Synchronize and convert databases from MS SQL 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! MSSQL2MySQL Sync is also applicable for MySQL database synchronization and migration to another MySQL database or even to another MySQL server. Moreover, MSSQL2MySQL Sync is quite well for MS SQL database synchronizing and migration to another MS SQL database or to a different MS SQL Server.

Safe data synchronization and database integrity
Don't care about safety of your data. Our converter will do it for you! MSSQL2MySQL Sync supports all base data types of MS SQL Servers 2000/2005 and MySQL server data types (including `BLOBs`, `ENUMs`, `SETs` and Data Arrays). Primary keys, indexes and foreign keys are supported in the best way.

Update and Insert synchronization
Keep all your databases up-to-date. Insert synchronization is meant for new records adding from a source to a destination database. Update synchronization is meant for replacing of the altered records in destination database. Together they allow keeping distributed databases in agreement.

Database objects (tables, fields, indexes and foreign keys) remapping for synchronization
Synchronize databases with different structures easily! All database objects (fields, indexes and foreign keys) can be remapped on the customization stage.

Full UNICODE architecture support
MSSQL2MySQL Sync is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.

Customize your data synchronization process and database copying totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.

Savable sessions
Save your sessions and use them again if you do not want to lose time for configuring source, destination database and other customizations for synchronization process.

Command line mode
Run MSSQL2MySQL Sync as a part of your automate solution to activate it from a command line with saved session name as a parameter.

Effective scheduler
Automate running of your MSSQL2MySQL Sync by using Data Conversions Scheduler! Convenient scheduler is available for all data converters, so you can run the program without user input after having scheduled it once.

Here are some key features of "MSSQL2MySQL Sync ":

· Insert-synchronization and Update-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. MSSQL2MySQL Sync 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;
· 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;
· Skins support;
· Multilanguage Support (English/French/Russian);
· 1-year free upgrades.


Requirements:

· Windows NT: Internet Explorer 4.01
· At least 32 MB of RAM
· Necessary privileges to write into database on the target MS SQL/MySQL server.
· MDAC 2.8