Versions Compared

Key

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

In Oracle to MSSQL SQL Server replication,If source Oracle database is running on Linux then setup wizard is executed on target Windows machine where MSSQL SQL Server database is running. 

Note

SQL Server Migration Assistant for OracleNavicat Premium can be used to load data from oracle to SQL Server in order to sync source and target environment before initiating replication.

...

This example shows an Oracle-to-MSSQL SQL Server one-way replication using the following information.

...

During this step the source and target databases are set for each replication pair. In Oracle to MSSQL SQL Server replication, Only Oracle database can ne source. 

...

Note

Rename SCHEMA name for avi.sample (empty means no rename): [] w420g.dbo
Here, w420g is the target MSSQL SQL Server database name and dbo is schema. Please use <targetDB>.<schema> format in "Rename Schema"

...

Note

Executing reptest2-all.bat script creates dbvrep database in MSSQL SQL Server to store metadata of replication. Set correct snapshot isolation for dbvrep. Click here for more info.

...