Bi-directional Database Synchronization Tool for Firebird and MySQL databases
DBSync for Firebird and MySQL is a powerful database sync tool designed to perform two-way conversion and synchronization from Firebird databases to MySQL server and from MySQL to Firebird. The tool is also applicable for MySQL database replication to another MySQL database and is quite versed in copying a Firebird database to another Firebird database.
It handles conversion and synchronization of InterBase databases too. DBSync for Firebird and MySQL provides the bulk of functional capabilities such as interactive (GUI) mode/command line mode, savable sessions, insert, update and Drop synchronization types included, task planner scheduling, data filtering, preverification of possible conversion errors, etc.
You can convert and synchronize Firebird with MySQL or MySQL with Firebird simply by configuring several options and by making some sync customizations through a Wizard interface or in command line mode. Command line parameters added to a scheduling function enables you to automatically synchronize or convert data regularly without user input and supplementary settings.
DBSync for Firebird and MySQL provides you with the ability to manipulate synchronization preferences on Customization stage exactly according to your needs. It allows to convert and replicate databases of old InterBase formats to Firebird and MySQL and vice versa.
Filtering data during conversion allows users to retrieve only specific data for converted tables according to defined filtering criteria. Filters give you more control on the data migration process. Possible synchronization errors can be detected before the conversion process gets started. The tool displays errors and potential problems with your table objects beforehand.
Here are some key features of "DBSync for Firebird and MySQL":
· Interactive (GUI) mode / command line mode;
· Foreign key (relations) support;
· All Firebird / InterBase versions support;
· Insert-synchronization, Update-synchronization and Drop-synchronization available;
Unicode Support/Connection character sets support:
· LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257,
· CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U,
· MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset);
· Binary data types support;
· `ENUM` and `SET` MySQL database types support;
· Automation of the conversion process with built-in scheduler;
· 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.
· Skins support;
· Multilanguage Support.
Requirements:
· No special requirements
Limitations:
· Allows you to process first 50 records of each table
What's New in This Release:
· InterBase version 6 and CodeGear InterBase 2009 support;
· Firebird version 1.0, 1.5, 2.0 and 2.1 support;
· Foreign keys (relations) support;
· Automatic synchronization process with built-in scheduler;
· Sessions support;
· Unicode and Binary data types support added.
Download
DBSync for Firebird and MySQL 1.2.0