Update Master Database Daily comparing with old one

[RAJAGOPAL PATABALLA]

Hi, We are working with one of the client We recieve daily updated database from client We have to compare the old database and the newly records should be updated Guide me how can we implement this logic in .net or any solution Regards RajaGopal India

[David Mujica]

I'm a bit confused. :confused: If you receive an updated database from your client on a daily basis, why don't you just replace the old database with the new one ? Otherwise, you will need to create a reconciliation program that considers the following: 1) New records 2) Deleted records 3) Update records You could apply this logic on a table by table basis, but the problem arises when there are constraints among dependent tables. If you try to insert a record in a table and the foreign key does not exist yet in the parent table you will get an insert error. One method around this is to drop all constraints when performing this reconcilliation and re-apply the constraints when the process is complete. Not an easy task. Best of luck.

[Henry Minute]

Assuming that your Database is MS SQL Server and that it is >= 2005, this[^] may be of interest to you.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[i i i]

You send whole database or part of the database means only those items which are updated or changed.

Best Regards, SOFTDEV If you have knowledge, let others light their candles at it