Target Database: SQL Server

Owned by Copy Space for Confluence
Last updated: Mar 31, 2017 by Lorraine Anderson (Unlicensed)
1 min read

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

If both source and target databases are running on Windows platform then System DSN (Data Source Name) with the same name are required on source and target machine.

If source is Linux then System DSN is only required on Windows target machine. 

For datatype mapping between Oracle and SQL Server, please see Supported Datatypes

  • Microsoft's SSMA, Navicat Premium or other 3rd party tools can be used to load data from oracle to SQL Server in order to sync source and target environment before initiating replication.
  • Currently, only truncate table is supported when DDL replication is enabled for Oracle to SQL Server Replication.
  • Timestamp datatype of Oracle is not supported for Oracle to SQL Server Replication.

MS 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]

Ensure that you are familiar and understand datatype mapping between Oracle and MS SQL - this will be crucial when designing your target SQL tables. Here is a nice overview of datatype mapping between Oracle and MS SQL https://msdn.microsoft.com/en-us/library/ms151817.aspx