Dbvisit Replicate supports (version XTD and MAX) supports One-to-many replication and this can be specified during the setup wizard.
During Step 1 of the setup wizard, more databases can be added. In the following example, there are 3 databases added. If you want add another database use option "add":
| No Format | ||
|---|---|---|
| ||
Step 1 - Describe databases
========================================
The first step is to describe databases used in the replication. There are usually
two of them (source and target); however, there can be just one (when
source and target is the same) or more than two (one-to-many or other complex
configurations.)
Following databases are now configured:
1: Oracle orcl, SYS/**, SYSTEM/*, dbvrep/**, USERS/TEMP, dbvrep/, ASM:YES,TZ: +00:00
2: Oracle test11202, SYS/**, SYSTEM/*, dbvrep/**, USERS/TEMP, dbvrep/, ASM:NO,TZ: +00:00
3: Oracle dbvisit210_d112f, SYS/**, SYSTEM/*, dbvrep/**, USERS/TEMP, dbvrep/, ASM:NO,TZ: +00:00
Enter number of database to modify it, or "add", or "done": [done] add |
During Step 2 of the setup wizard the configuration pairs can be specified. In this example, orcl is the source database and test11202 and dbvisit210_d112f are the target databases. If you want to add another pair use option "add" else press enter on keyboard.
| 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 as source and the second one as target, but many more configurations are possible. Following replication pairs are now configured: Following replication pairs are now configured: 1: orcl(Oracle) ==> test11202 (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix), compression: no, encryption: no, network timeout: 60, prepare type: single-scn, data load: dp_networklink 2: orcl(Oracle) ==> dbvisit210_d112f (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix), compression: no, encryption: no, network timeout: 60, prepare type: single-scn, data load: dp_networklink Enter number of replication pair to modify it, or "add", or "done": [done] |
...