Versions Compared

Version Old Version 9 New Version 10
Changes made by

KrupeshD (Deactivated)

KrupeshD (Deactivated)

Saved on

Key

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

In Oracle to MSSQL SQL Server replication,If both source and target databases are running on Windows OS then setup wizard is executed on source Windows machine.

...

This example show 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.

...