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 |
|
deepgeorge
Starting Member
6 Posts |
 Posted - 2008-05-13 : 04:43:32
|
| I am looking for an efficient mechanism to compare data between 2 tables/views.Rationale:I use a proprietary tool to data transfer between 2 databases. The tool itself uses Microsoft SSIS (integration service) to transfer data. I want to make sure that the data is transfered properly. Both the source and target database are not live database. The source and target database are in seperate servers. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-13 : 04:58:06
|
| You need to use third-party tools like RedGate Data Compare or ApexSQL Diff.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
deepgeorge
Starting Member
6 Posts |
Posted - 2008-05-13 : 06:40:08
|
| Thank you. but i am looking for an efficient algorithm for the same. |
|
|
|
|
|
|
comparing data in tables/views.