Versions Compared

Key

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

...

If both source and target databases are running on Windows platform then DSN (Data Source Name) with the same name are required on source and target machine. But if source is Linux then DNS is only required on Windows target machine. 

Note
  • SQL Server Migration Assistant for Oracle Navicat Premium can be used to load data from oracle to SQL Server in order to sync source and target environment before initiating replication.
  • Currently, no DDL replication is supported for Oracle to SQL Server Replication.
  • Timestamp datatype of Oracle is not supported for Oracle to SQL Server Replication.