...
During this step the source and target databases are set for each replication pair. In Oracle to SQL Server replication, Only Oracle database can ne be source.
| No Format | ||
|---|---|---|
| ||
Step 2 - Replication pairs ======================================== The second step is to set source and targets for each replication pair. This is usually just choosing the first database a source and the second one as target, but many more configurations are possible. Let's configure the replication pair, selecting source and target. Following databases are described: 1: reptest2 (Oracle) 2: mstest (MSSQL) (cannot be source, is not Oracle) Select source database: [1] Select target database: [2] Use fetcher to offload the mining to a different server? (yes/no) [no] (NETWORK_QUALITY) - Please specify your network type (LAN or WAN). Autoconfigures timeouts, use of compression etc. [LAN] Lock and copy the data initially one-by-one or at a single SCN? (one-by-one/single-scn/ddl-only/resetlogs) [single-scn] Following replication pairs are now configured: 1: reptest2 (Oracle) ==> mstest (MSSQL), DDL: no, fetcher: no, process suffix: (no suffix), network: LAN, prepare type: single-scn, data load: ddl_file Enter number of replication pair to modify it, or "add", or "done": [done] |
...