 |
| ||||
DBSync for Oracle and MySQL is an easy-to-use database synchronization utility which performs two-way conversion and synchronization from Oracle databases to MySQL server and from MySQL to Oracle. The tool is also applicable for MySQL database replication to another MySQL database and is quite adept at copying a Oracle database to another Oracle database.
DBSync for Oracle 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 Oracle with MySQL or MySQL with Oracle 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 Oracle and MySQL provides you with the ability to manipulate synchronization preferences on Customization stage exactly according to your needs. The users can retrieve only certain data from the converted tables by filtering data during conversion.
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 Oracle and MySQL":
· Primary keys and Indexes support;
· Foreign key (relations) support;
· Insert-synchronization, Update-synchronization and Drop-synchronization available;
· Database objects (tables, fields , indexes and foreign keys) remapping;
· Oracle Server version 10.0 and higher support;
· ODBC Oracle and Oracle client are not required;
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, UTF8 (unicode charset);
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;
· `BINARY` conversion support;
· Skins support;
· Multilanguage Support;
· In teractive (GUI) mode / command line mode;
· 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 built-in scheduler;
· Data mapping - simple data types' assignment for a destination database to match one data type to its closest equivalent in the target fields;
· Ability to select table types when copying data to MySQL;
Requirements:
· At least 32 MB of RAM
· Necessary privileges to write into database on the target Oracle/MySQL server.
· MySQL 4.x/5.x
· Oracle 10.x.x
· Microsoft Visual C++ 2008 x86 Redistributable package
Limitations:
· 50 records from each table
What's New in This Release: [ read full changelog ]
· Variable quantization step added.
Via: DBSync for Oracle and MySQL 1.5.0
