Versions Compared

Version Old Version 18 New Version Current
Changes made by

KrupeshD (Deactivated)

Max Surtaev (Deactivated)

Saved on

Key

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

In all replications, the source database must be an Oracle database. Therefore, two-way replication with MS SQL with SQL Server is not supported. ODBC connection is used to connect to MS SQL, thus to SQL Server, therefore System DSN (Data Source Name) with the same name must be setup created by the system administrator on both source and target systems.

If both source and target databases are running on Windows platform then DSN then System DSN (Data Source Name) with the same name are required on source and target machine. But if source is Linux then DNS System DSN 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 MS Oracle to SQL Server Replication.Oracle
  • on Windows to MSSQL replication is a beta feature and it will be fully supported in next release. Oracle on Lunix/Unix to MSSQL replication is fully supportedTimestamp datatype of Oracle is not supported for Oracle to SQL Server Replication.
Note
titleMS SQL Server specific

Name of the target tables has to contain three parts: DATABASE, SCHEMA, TABLENAME

Questions in the wizard, step 1, database type SQL Server:

Enter the schema the table are created by the user specified: [SCHEMA]

Enter the database with the user data: [DATABASE]