Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

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

theme	Confluence
language	sql

select count(*) 
from 
( 
( select * from tab1@source 
minus 
select * from tab1@target ) 
union all 
( select * from tab1@target 
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