Detect Database changes with Ado.Net?

[AvatarZA]

I would like to know if there is a way to dectect the differences/changes between two db's using Ado.Net?

A bit of background I have a program that will update a client db, this program has what the db structure should

look like. I need to make the client db look like the master with the same tables, fields and relationships

etc...

If there isn't a way with Ado.Net if there is any other way I would also apprectiate that or any other ideas.

Thanks a lot in advance.

 

[DotNetDoc]

If I understand you question correctly you should look into DTS and SqlServer Replication Services.

DotNetDoc
M.C.S.D.
---------------------------------------

Tell me and I forget. Show me and I remember. Involve me and I understand.
- Anonymous Chinese Proverb

-----------------------------------

If you can't explain it simply, you don't understand it well enough.
- A. Einstein

 

[AvatarZA]

The program also uses a Microsoft Access 2000 database how could I get the difference's between the master that I have and the Access db.

P.s The master is a Access db.