Frequently Asked Questions for Oracle-MySQL Sync |
| [Oracle-MySQL Sync] [Download] [Buy] |
On this page you can find the most frequently asked questions regarding Oracle-MySQL Sync. If your question is not answered here, please contact us via Feedback Form
What versions of Oracle are supported?
Oracle-MySQL Sync works with all versions of Oracle running on Linux/Unix and Windows platforms.
Go to Top
What versions of MySQL are supported?
Oracle-MySQL Sync works with all versions of MySQL including such forks
(variations) as MariaDB and Percona.
Go to Top
Does Oracle-MySQL Sync require Oracle environment?
Oracle-MySQL Sync does not require Oracle environment.
Go to Top
What is "full" and "incremental"
synchronization?
Oracle-MySQL Sync uses full synchronization to make source and destination tables
identical at first run, when the program does not have information about difference
between those two tables. Full synchronization includes two phases:
If "drop synchronization" is OFF, the second step is omitted. Full synchronization can take a long time on large tables since it requires reading entire source and destination tables record by record.
Incremental synchronization updates only rows that were inserted, updated or
deleted in the source table. This option is available starting from the second
run of Oracle-MySQL Sync, after the program prepared all necessary objects to
store history of changes.
Go to Top
I can see strange table "__history__" and
some triggers created in the database being synchronized. Why?
Oracle-MySQL Sync creates this table and triggers in order to implement
incremental synchronization i.e. synchronize only the data that has been
updated since previous run.
Go to top
What is the difference between synchronization in
Oracle-to-MySQL and Oracle-MySQL Sync?
Oracle-to-MySQL implements only full one-direction synchronization from
Oracle to MySQL and it cannot do incremental synchronization in next runs.
Oracle-MySQL Sync implements full bi-directional synchronization between
Oracle and MySQL. Also, it can do incremental synchronization i.e. update
only data being changed.
Go to top
After running full synchronization in demo version
of Oracle-MySQL Sync, source and destination tables are not identical. Why?
Demo version of Oracle-MySQL Sync scans only first 50 rows in each table
for synchronization purpose. This limitation does not appear in full version
of the product.
Go to top
It is possible to connect to MySQL over SSH
with Oracle-MySQL Sync?
Yes, Oracle-MySQL Sync supports SSH connection to MySQL server. Please refer to
this article for the further information.
Go to Top
Does Oracle-MySQL Sync support automation?
The product does not support automation directly. However, there
is console version of the program o_sagent.exe in the installation directory.
It supports command line arguments and can be called from any script. So,
it is possible to write a simple batch script and execute it recurrently using
Windows Task Scheduler. Please refer to
"Command line" article of the product documentation to learn
more about o_sagent.exe.
Go to Top
How to uninstall Oracle-MySQL Sync?
If you need to remove Oracle-MySQL Sync products from your
computer, you can use "Add or Remove Programs" option in the
Windows Control Panel.
Go to top