compare records between 2 tables 
Author Message
 compare records between 2 tables
Hello,
I've written a replication script between an Intranet DB and Internet DB.
Now, to test the replication, i would like to check the records between my
two DB for the replicated tables to verify that everithing is well updated.
I would like to check if, for the same primary key, the stored information
is the same on the 2 DB.
If you have suggestions, they are wellcome ;-)

Thank you for your help



Sat, 22 May 2004 22:21:40 GMT
 compare records between 2 tables



Quote:
>Hello,
>I've written a replication script between an Intranet DB and Internet DB.
>Now, to test the replication, i would like to check the records between my
>two DB for the replicated tables to verify that everithing is well updated.
>I would like to check if, for the same primary key, the stored information
>is the same on the 2 DB.
>If you have suggestions, they are wellcome ;-)

>Thank you for your help


minus
select * from foo
/

Easy

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address



Sun, 23 May 2004 02:51:38 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Need Help: Tracking changes and comparing records in a table question

2. compare all the records of all the fields of two tables

3. Comparing 2 tables of records in Access using VB

4. 1 table for many records or many tables with few records

5. Cannot add record to Visual Foxpro table after deleting all records in table

6. one table with lots of records or more table with less records

7. Fetch record into a plsql table (record.column_1 into table(index_1))

8. Compare Table against Full Text Indexed Table

9. Comparing two tables and appending data to destination table

10. Comparing tables to tables(????)

11. Comparing table contents of two tables

12. Comparing fields in same record - Complex


 
Powered by phpBB® Forum Software