FoxPro2MySQL Sync description
FoxPro2MySQL Sync is a reliable bi-directional database migration tool which allows you to synchronize and convert database

FoxPro2MySQL Sync is a reliable bi-directional database migration tool which allows you to synchronize and convert database:
· MS Visual FoxPro to MySQL
· MS Visual FoxPro to MS Visual FoxPro
· MySQL to MS Visual FoxPro
· MySQL to MySQL

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!

FoxPro2MySQL Sync is also applicable for MySQL database synchronization and migration to another MySQL database or to another MySQL server. Moreover, FoxPro2MySQL Sync is quite well for copying and synchronizing MS Visual FoxPro database and MS Visual FoxPro separate tables with another MS Visual FoxPro database.

High data conversion speed and performance
Try it now and make sure that it`s true! FoxPro2MySQL Sync establishes a direct connection to source and destination databases. It is developed exactly for solving your problem with minimum efforts and time!

Lossless data synchronization and database integrity
Don`t care about safety of your data. Our synchronizer will do it for you! FoxPro2MySQL Sync supports all MySQL server and MS Visual FoxPro data types (except `OLE Object` packages). Primary keys, indexes and foreign keys (relations in MS Visual FoxPro) 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
FoxPro2MySQL Sync is based on full Unicode architecture with multibyte character sets support. It is compatible with Unicode utf-8/16

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 or excluded.

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

Command line mode
Run FoxPro2MySQL 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 FoxPro2MySQL 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 "FoxPro2MySQL Sync":

· 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.
· Unicode support/Supported charsets 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:

· Does not convert system (hidden) tables.
· Does not convert linked tables.
· Does not support `OLE Object` packages.
· Does not convert compound foreign keys to MS Visual FoxPro.
· The demo allows you to process first 10 records of each table