In Oracle to MSSQL replication,If both source and target databases are running on Windows OS then setup wizard is executed on source Windows machine.
| Note |
|---|
Windows to Oracle - to MSSQL replication is a beta feature and it will be fully supported in next release. Oracle on Lunix/Unix to MSSQL replication is fully supported
- SQL Server Migration Assistant for Oracle can be used to load data from oracle to SQL Server in order to sync source and target environment before initiating replication.
|
Setup Wizard Example
This example show an Oracle-to-MSSQL one-way replication using the following information.
...