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 |
...
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. |
...