How to check that DB2 is same as DB1 in every thing ?
761559May 3 2011 — edited May 8 2011Dears,,
In our environment, we have two databases: DB1(Live),DB2(Test).
every thing done on DB1, also done on DB2
So, may be in sometimes we found that both databases are not synchronized and not same.
We need every month to make checkup between them to check that they are same in (tables,packages,procedures,indexes, . . . etc and every thing).
In another meaning: Check that DB2 is copy from DB1.
Please, how can make this check?
Many thanks for advise