Bi-directional synchronization and convertion for MS FoxPro and MySQL databases

DBSync for MS FoxPro & MySQL is a database synchronizer which performs MS FoxPro to MySQL and MySQL to FoxPro database conversion and synchronization simply by configuring several options in a wizard-like application.

It gives you a chance to not only convert your data with synchronization, but also to choose a particular number of tables to be converted and organize application work using command line parameters, choosing whether to copy the identical records from source database to the destination database or not. DBSync for MS FoxPro & MySQL offers high speed synchronization and provides you with the opportunity to select Updatem Drop and Insert types and 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. DBConvert Scheduler gives you an opportunity to run DBSync for MS FoxPro & MySQL program sessions and any other applications on a user defined schedule that means that you can run programs without user control after having scheduled task once.

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

· Interactive (GUI) mode / command line mode;
· MS Visual FoxPro version 9.0 and early support;
· Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MySQL internal purposes) with a substitute symbol;
· Automation of the conversion process with task scheduler;
· Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL;
· Unicode support/Supported charsets
· for FoxPro:
· U.S. MS-DOS, Mazovia MS-DOS, Greek MS-DOS, International MS-DOS, European MS-DOS, Turkish MS-DOS, Icelandic MS-DOS, Nordic MS-DOS, Russian MS-DOS, Thai Windows, Kamenicky MS-DOS, Japanese Windows,Chinese Simplified Windows, Korean Windows, Traditional Chinese Windows, European Windows, Russian Windows,Windows ANSI, Greek Windows, Turkish Windows, Hebrew Windows, Arabic Windows, Standard Macintosh, Greek Macintosh, Russian Macintosh, Macintosh EE.
· for MySQL:
· LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, UTF8 (unicode charset)
· Primary keys and Indexes 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 then.
· `ENUM` and `SET` MySQL database types support;
· MS Visual FoxPro free tables support;
· Skins support;
· Multilanguage Support.


Requirements:

· At least 32 MB of RAM
· Necessary privileges to write into database on the target MS SQL server.


Limitations:

· Only 10 records will be processed
· Nag screen