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 |
|
Jarrodr
Starting Member
11 Posts |
 Posted - 2008-06-04 : 03:40:05
|
| Hi everyone,I have recently converted my DTS packages to SSIS and deployed them to the new server. I have the 2000 and 2005 server running concurrently, all that is left for me to do is compare the the tables generated by the DTS and SSIS packages to see if they are the same. How do I go about comparing the tables, which are from two different servers using SQL server 2005? Thank you inadvance:)Comparing data and integrity between two tables |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 09:31:17
|
| It should be same . |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-04 : 23:00:32
|
| Sql2k5 comes with tablediff.exe that does what you need to do. |
|
|
|
|
|
|
Comparing data and integrity between two tables