By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

How to compate two versions of the same database

RedSon
Expert 5K+
P: 5,000
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!
May 21 '09 #1
Share this Question
Share on Google+
5 Replies


RedSon
Expert 5K+
P: 5,000
It's SQL Server Compact, thats the official name.
May 21 '09 #2

ck9663
Expert 2.5K+
P: 2,878
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
May 22 '09 #3

RedSon
Expert 5K+
P: 5,000
No, the idea is to not overwrite just compare.
May 22 '09 #4

ck9663
Expert 2.5K+
P: 2,878
RedSon,

Will this work?


--- CK
May 25 '09 #5

RedSon
Expert 5K+
P: 5,000
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 :)
May 26 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.