Bi-directional synchronization and conversion for MS SQL and MySQL databases

DBSync for MS SQL & MySQL is a database synchronizer which performs SQL to MySQL and MySQL to MS SQL database conversion and synchronization simply by configuring several options in wizard-like application. This tool gives you chance not only convert your data with synchronization, but there is also a possibility to choose particular number of tables for synching.

You can organize application work using command line parameters and choose whether to copy the identical records from source database to the destination database or not. The program provides high speed synchronization and gives the opportunity to select Insert, Update and Drop types of synching. All options selected initiate full database synchronization. You can check each program step with savable log files and run again synchronization with stored session files that keep all your settings inside.

DBConvert Scheduler gives you an opportunity to run DBSync for MSSQL & MySQL program sessions and any other applications on a user defined schedule that means that you can run programs without user input after having scheduled it once. Features: Unicode Support, Primary keys and Indexes conversion, Interactive multilingual (English, German, French, Russian) GUI mode/advanced command line mode, data filtering, renaming of tables, fields and indexes before conversion.

For data protection during synchronization process you can open SSH tunnel for secure communication between remote computers using data encryption. One of the key things of database managing is the ability to filter data during conversion and synchronization. Integrated data filters allow users to retrieve only specific data for synchronized tables according to defined filtering criterias (conditions). You will gain more control over the data migration process due to the filters.

To guide you through all synchronization stages and settings adjustment for Filters, SSH and customization options the detailed help file is enclosed as well.

Here are some key features of "DBSync for MSSQL & MySQL":

￭ Microsoft SQL Server Express and Microsoft SQL Server 2000/2005 support
￭ 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. DBSync for MSSQL & 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;
￭ 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.
essions 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:

￭ At least 32 MB of RAM
￭ Necessary privileges to write into database on the target MS SQL/MySQL server.
￭ MDAC 2.8


Limitations:

￭ 10 runs trial
￭ Only 10 records will be processed
￭ Nag screen