DBSync for MySQL & DB2

Bi-directional Database Synchronization Tool for MySQL and DB2 databases
Download

DBSync for MySQL & DB2 Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Shareware
  • Publisher Name:
  • DMSoft Technologies
  • Operating Systems:
  • Windows 7/Vista/XP/2000/NT
  • File Size:
  • 19.05MB

DBSync for MySQL & DB2 Tags


DBSync for MySQL & DB2 Description

DBSync for MySQL & DB2 is a database synchronization tool which performs two-way conversion and synchronization from MySQL databases to DB2 and from DB2 to MySQL. The tool is also applicable for MySQL database replication to another MySQL database and is quite adept at copying DB2 to another DB2 database. DBSync for MySQL & DB2 provides the bulk of functional capabilities such as interactive (GUI) mode / command line mode, CLOB, BLOB DB2 data types smooth conversion to MySQL types, insert, update and drop synchronization types, advanced customization options, ability to save sessions for further use, flexible task scheduling with built-in scheduler, data filtering, preverification of possible conversion errors, etc. You can convert and synchronize MySQL with DB2 or DB2 with MySQL 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 MySQL & DB2 provides you with an 'Insert sync' function that was designed to help you add new records from a source to a destination database. Update sync is intended for replacing the altered records in a destination db. Drop sync type allows users to delete records from a destination db if these records were removed in the source. Update, Insert and Drop synchronization together allow keeping distributed databases in agreement. DBSync for MySQL & DB2 provides you with the ability to manipulate synchronization preferences on Customization stage exactly according to your needs. 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 potential problems with your table objects beforehand. Main features: Interactive (GUI) mode / command line mode; CLOB, BLOB, BINARY LARGE OBJECT DB2 data types smooth conversion to MySQL types; Saving data into a MySQL Dump and PHP script for export to MySQL database; 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; Automation of the conversion process with task scheduler; 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); Primary keys and Indexes support; Foreign keys (relations) support; Advanced customization options: partial selection for database objects to be converted; database objects (tables, fields, indexes, foreign keys) tuning up before conversion; detection of possible conversion errors on customization stage. Sessions support - all your settings can be saved and restored later; Ability to connect to MySQL database servers and DB2 servers located on all Unix-like and Windows machines; Skins support; 1-year free upgrades.


DBSync for MySQL & DB2 Related Software