...
| Note |
|---|
Run APPLY.sh script on target machine to export data from source database and load into target database to create a starting point from where replication can be initiated. Click here for more information on creating starting point. Make sure you review APPLY.sh before running the script.
For one-way replication please ensure all triggers are disabled or dropped for the replicated tables/schemas after importing on target else this could lead to data divergence. The trigger has already fired on the source & the resultant transactions will be replicated to the target so there is no need to have them fire again. Same is true for delete cascade constraints as they need to be disabled prior to starting up APPLY process. Sample sql for disabling the delete cascade constraints can be found at Constraints. If you had any LOB columns with NOT NULL constraints these also need to be deferred or disabled on the target.
|
As indicated by the Nextsteps.txt , the replication can be started by following the steps that are listed above.
...