When is the source and target are fully synchronized with Dbvisit Replicate?
...
- Make your console screen bigger and the console will automatically adjust to fit more on the screen
- Run command: "list progress". This will give a static output of the full progress report
- Run command "NOTIFY SEND DAILY_PROGRESS" and this will email the progress report in full
Manually comparing the data between source and target and optionally applying the differences
Please see http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_comparison.htm for the use of DBMS_COMPARISON to compare both datasets and generate SQL for the differences.
Another option is to run the following SQL:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
select count(*) from from ( ( select * from tab1@source tab1@source minus minus select * from tab1@target ) union all all ( select * from tab1@target tab1@target minus minus select * from tab1@source ) ) |
Commercial products
There are commercial products available to compare data between 2 databases. One such tool is Redgate Data Compare for Oracle