Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before starting replication, source and target environment must be in sync. If source objects arenot empty then source data must be loaded into target (MySQL) database. You can use Navicat Premium to load data from Oracle to MySQL.

Setup Wizard Example

This example shows an Oracle-to-MySQL one-way replication using the following information.

...

Now, all insert, update and delete operation on avi.sample table of Oracle will be replicated to reptest1.sample table of MySQL.

Note
  • Database and table names are case sensitive in MySQL
  • Scitps generated by setup wizard contains plain text passwords. You can delete these scripts once replication is configured and running.