...
If both source and target databases are running on Windows platform then System DSN (Data Source Name) with the same name are required on source and target machine. But if source is Linux then System DSN is only required on Windows target machine.
| Note |
|---|
For datatype mapping between Oracle and SQL Server, please see Supported Datatypes |
| Note |
|---|
- Microsoft's SSMA, Navicat Premium or other 3rd party tools can be used to load data from oracle to SQL Server in order to sync source and target environment before initiating replication.
- Currently, only truncate table is supported when DDL replication is enabled for Oracle to SQL Server Replication.
- Timestamp datatype of Oracle is not supported for Oracle to SQL Server Replication.
|
...