Versions Compared

Key

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

...

  • In all replications, source must be an Oracle database. Thus, two-way replication with MySQL and SQL Server as target is not supported.
  • DDL replication is not supported for MySQL and SQL Server as target.  The one DDL command that is supported is TRUNCATE.
  • Datatypes must be mapped between Oracle to MySQL/SQL Server otherwise replication may fail.Example: timestamp datatype of Oracle is not available in SQL Server and MySQL.
  • Deferrable constraints do not work on MySQL and SQL Server.  If you have them on the Oracle side you should disable them.

Anchor
tns_non_ora
tns_non_ora
Configuring TNS_ADMIN For Non Oracle Replication

...