DBConvert for FoxPro & MySQL 2.1.0

DBConvert for FoxPro & MySQL 2.1.0 delivers the best and easiest converting way to 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!

DBConvert for MS SQL & MySQL is also applicable for MySQL database migration to another MySQL database or to another MySQL Server. Moreover, DBConvert for MS SQL & MySQL is quite well for MS SQL database migration to another MS SQL database or to another MS SQL Server.

Benefits:

1. High data synchronization speed and performance. Try it now and make sure that it`s true! DBSync for FoxPro & MS SQL establishes a direct connection to source and destination databases. Thanks to improved quality of synchronization, data are transferred much faster and more accurate in comparison with lots of universal synchronizers which use ODBC or ADO. It is developed exactly for solving your problem with minimum efforts and time!
2. Preverification of possible conversion errors. Verify possible conversion errors before the conversion process gets started! To prevent is better than to correct! Our tool displays errors and potential problems with your table objects beforehand. Some errors that could bring to the conflict on a destination database are easy to eliminate by a small reconfiguration of the conversion process issues in one touch.
3. Lossless data synchronization and database integrity. Don`t care about safety of your data. Our converter will do it for you! DBSync for FoxPro & MS SQL supports all MS SQL 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.
4. Conditional data migration. Manage your database conversion with the help of integrated data filters. Define filtering conditions and retrieve only the specific data that you need for conversion. Due to our data filters you get more control on data migration process.
5. Update, Insert and Drop 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. Drop-synchronization allows users to delete records from destination database if these records were removed in source. Together they allow keeping distributed databases in agreement.
6. Database objects (tables, fields, indexes and foreign keys) remapping for synchronization
7. Synchronize databases with different structures easily! All database objects (fields, indexes and foreign keys) can be remapped on the customization stage.
8. Full UNICODE architecture support. DBSync for FoxPro & MS SQL is based on full Unicode architecture with multibyte character sets support. It is compatible with Unicode utf-8/16
9. 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.
10. 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.
11. Command line mode. Run DBSync for FoxPro & MS SQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.
12. Flexible Scheduling. Raise the productivity of your work up. Conversion and synchronization task managing is performed in all DBConvert tools with built-in Scheduling stage. Using sessions and batch files as parameters the scheduled tasks will automatically work as services in background mode giving you an opportunity to keep them unattended.

Major Features:

1. Microsoft SQL Server Express and Microsoft SQL Server 2000/2005 support
2. Interactive (GUI) mode / command line mode;
3. MS Visual FoxPro version 9.0 and early support;
4. Foreign key (raletions) support
5. Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support;
6. Insert-synchronization, Update-synchronization and Drop-synchronization available;
7. Automation of the conversion process with task scheduler;
8. Ability to select TCP/IP, PIPE, IPX/SPX communications protocols;
9. 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
10. Primary keys and Indexes support;
11. MS SQL schemes support;
12. 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.
13. Sessions support - all your settings can be saved and restored then.
14. MS Visual FoxPro free tables support;
15. Skins support;
16. Multilingual support.

Enhancements:

• Advanced command line processing added.
• Data filters support added.
• Fresh design.
• SSH support.
• Multilingual GUI
  

Requirements:

• Windows Vista/XP/2000/NT (NT only with 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