DBSync for MS SQL & MySQL 2.1.0

DBSync for MS SQL & 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. Safe data conversion and database integrity. Don’t care about safety of your data. Our converter will do it for you! DBConvert for MS SQL & MySQL supports all base data types of MS SQL Servers 2000/2005 and MySQL server data types (including `BLOBs`, `ENUMs`, `SETs`). Primary keys, indexes and foreign keys are supported in the best way.
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. Optimal data mapping. Simple data types assignment for a destination database in one touch. Just choose data types you need for the target fields or the most appropriate data types for the source type and our program will automatically transform types from one specific format to another.
4. Workaround problems with firewalls and access rights. Use our workarounds as MySQL Dumps, MS SQL Dump and PHP Scripts if you don't have a direct access to MySQL Server or MS SQL Server! Dump file can be used if you have no direct access to server, but can execute SQL-scripts, for example through phpMyAdmin or other tools. PHP Script is used if you don't have a direct access to database server, but have an ftp and PHP access. DBConvert for MS SQL & MySQL generates a PHP-script that contains database info inside and can be executed on the server to put database there
5. Full UNICODE architecture support. DBConvert for MS SQL & MySQL is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.
6. Customize your data conversion process and database copying totally. Copy your database as is or with modified structure! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed or excluded.
7. 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.
8. 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 conversion process.
9. Command line mode. Run DBConvert for MS SQL & MySQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.
10. 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. Saving data into a MySQL Dump, PHP script for export to MySQL database;
4. Saving data into a MS SQL Dump for export to MS SQL database;
5. Shared memory, TCP/IP support;
6. 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;
7. Automation of the conversion process with task scheduler;
8. Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL or MySQL Dump;
9. Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support;;
10. Primary keys and Indexes support;
11. Foreign key (relations) support;
12. MS SQL schemes support;
13. 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.
14. Sessions support - all your settings can be saved and restored then.
15. `ENUM` and `SET` MySQL database types support.
16. Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
17. Skins support.
18. Multilanguage Support
19. 1-year free upgrades.

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