DBSync for Oracle and MySQL

DBSync for Oracle & MySQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:

• Oracle to MySQL
• Oracle to Oracle
• MySQL to Oracle
• MySQL to MySQL

Synchronize and convert databases from Oracle to MySQL or from MySQL to Oracle 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! DBSync for Oracle & MySQL is also applicable for MySQL database synchronization and migration to another MySQL database or even to another MySQL server. Moreover, DBSync for Oracle & MySQL is quite well for Oracle database synchronizing and migration to another Oracle database or to another Oracle Server.

As you know the conversion speed depends on different things: the source file size, the computer performance, the output settings and so on. Now you don't need to search any tips to speed up the conversion. To increase conversion speed we improved our engine for large databases, with approximately 500 thousand records and more. Now they can be converted in 3-5 min.

Keep all your databases up-to-date with trigger-based instant synchronization method. Using our pre-created triggers you can notice that the synchronization speed is faster in times. Read more about this feature here.

Features
• 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;
• Interactive (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;
• 1-year free upgrades.

Requirements| Replicate Databases Oracle to / from MySQL server

• Necessary privileges to write into database on the target Oracle / MySQL server
• MySQL 4.x/5.x
• Oracle 10.x.x. / Oracle XE (Express Edition)
• Microsoft Visual C++ 2008 x86 Redistributable package