How to compate two versions of the same database

[RedSon]

Hi all,

I have two databases with identical schema. One was populated with information a while ago and one has since been updated. Is there a simple query I can run on a per table bases that will compare all rows and output the rows that have changed?

Its for SQL Server Mobile not SQL Server 2008 or anything. So my SQL is somewhat limited. Pretend it's vintage 2000 database engine.

Thanks for you help!

[RedSon]

It's SQL Server Compact, thats the official name.

[ck9663]

I believe there are utilities out there that you can use to compare two databases. If you want it manually, try this. But that's only for tables. What about other objects?

Can't you just define which one is the primary and use that to overwrite the other?

--- CK

[RedSon]

No, the idea is to not overwrite just compare.

[ck9663]

RedSon,

Will this work?


--- CK

[RedSon]

The SQL Server CE I am using does not support stored procedures, but I can use some of the information you have provided. Thanks! I will look it over and try to solve the issue :)