Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-13 : 07:19:59
|
| Mr. Joe writes "I have two databases that reside on the same SQL server. The structure is supposed to be the same but I suspect data in the newer one is missing. There are too many records to do a manual comparison. I'm looking for a way to compare the differences between tables on separate databases. Can anyone help me with query for this or know of a tool that will compare all the user tables for two seperate databases and tell you if there are any differences in the sturcture or the data?My applogies if this has been answered already. I didn't see anything in the search or in online books that specifically addressed this." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-13 : 07:47:05
|
| Red Gate Data / sql Compare .They have an advert occasionally at the top of the page on here.-------Moo. :) |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-04-13 : 08:02:53
|
| SQL Compare will compare the structure and Data Compare (both from red gate) will compare the actual contents of the tables. There are other programs though which as mr mist says are frequently advertised on these pagesA sarcasm detector, what a great idea. |
|
|
|
|
|
|
Tool for finding the difference between two SQL databases.