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 |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2011-01-26 : 04:50:50
|
| Hi,I need to check that, after a code-automated copy job, a set of tables in two databases on two different and geographically separated servers are identical. I'm not sure how best to do this. So far in early testing I've just been running a bit of t-SQL to count the tables. But for final testing I could do with something a bit more robust - counting rows & columns for example or perhaps the size of the files powering the tables. Can anyone advise on the best way to check this, and offer some appropriate T-SQL?Cheers,Matt |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-26 : 05:44:23
|
Transact Charlie has written a good script for checking Schematic Differences.Maybe it is helpful for you when using linked server...See here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136699
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
mattt
Posting Yak Master
194 Posts |
Posted - 2011-01-26 : 06:05:06
|
| Great, thanks. |
|
|
|
|
|
|
Check fiedelty of tables across 2 servers