Versions Compared

Key

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

...

Note
  • 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.
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]