DBSync for FoxPro & MySQL

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

• MS Visual FoxPro to MySQL
• MS Visual FoxPro to MS Visual FoxPro
• MySQL to MS Visual FoxPro
• MySQL to MySQL
• MySQL to *.DBF
• *.DBF to MySQL
• FoxPro 2.6 to MySQL
• MySQL to FoxPro 2.6

Synchronize and convert databases from MS Visual FoxPro to MySQL or from MySQL to MS Visual FoxPro 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 simple configuring of several options through Wizard interface or in command line mode! DBSync for FoxPro & MySQL is also applicable for MySQL database synchronization and migration to another MySQL database or to another MySQL server. Moreover, DBSync for FoxPro & MySQL is quite well for copying and synchronizing MS Visual FoxPro database (.dbc) and MS Visual FoxPro free tables (.dbf) with another database formats.

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 3-5 min.

Features
• 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;
• Insert-synchronization, Update-synchronization and Drop-synchronization available
• 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;
• Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
• Skins support;
• Multilanguage Support.

Requirements| Synchronize FoxPro to / from MySQL

• Necessary privileges to write into database on the target MS SQL server
• MySQL 4.x/5.x
• FoxPro 9.x, 2.6 and later
• Microsoft Visual C++ 2008 x86 Redistributable package