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 |
|
rv
Starting Member
11 Posts |
 Posted - 2008-07-21 : 16:41:12
|
| Hi, I was wondering if the tablediff utility of MS SQL 2005 can be used with respect to each column to find the difference of data in two similar tables.... C:\Program Files\Microsoft SQL Server\90\COM>tablediff -sourceserver "SQL2005" -sourcedatabase "DB1" -sourcetable "YY" -destinationserver "SQL2005" -destinationdatabase "DB1" -destinationtable "XX" -f "c:\Diff" Here in the above command line the difference can be taken out with the script....but is that possbile to incude the name od the source and destination columns to find the difference ? Any Suggestion ? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 23:02:16
|
| Did you check syntax in books online? Tablediff will tell you which column is different in the table. |
 |
|
|
rv
Starting Member
11 Posts |
Posted - 2008-07-22 : 11:27:44
|
| Yes this works fine and the syntax is also correct . Can you explainn me the syntax using the same command line for coulmn level diff -c switch ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-22 : 23:32:00
|
| Give you more details at column level? Try it then compare the result with previous one. |
|
|
|
rv
Starting Member
11 Posts |
Posted - 2008-07-23 : 11:51:59
|
| Can you explainn me the syntax using the same command line for coulmn level diff -c switch ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-24 : 14:22:07
|
| You can get it in books online. |
|
|
|
|
|
|
Tablediff Utility of MS SQL 2005 --- is it possibl