I have two databases on same server. In DB2 I have already 400 million records. I tried to load more 100 million records from DB1 to DB2 on top of existing 400 million records but after an hour I got the unique constraint error from DB2. The load has been failed after inserting 70% records.
Now I have three tasks. First I have to find the duplicate record between DB1 and DB2. Second I have to find out the remaining 30% records. Third I have to re-load the remaining 30% records.
I tried to find out the duplicates between DB1 and DB2 but my query is not ending. The unique constraint is based on composite key (charge_id, start_date). Can you give me the better and fast solution?

 out of  found this valuable. Do you find this valuable?    

Show Last Reply