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 |
|
turbo
Starting Member
19 Posts |
 Posted - 2010-09-06 : 09:23:00
|
| can u help me in comparing 'n' number of tables(data in the table) in two DBs. thks in adv |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-06 : 13:47:16
|
| you mean you need a generic proc for that?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
turbo
Starting Member
19 Posts |
Posted - 2010-09-09 : 02:44:02
|
| yeah i need help in a genaric SP . which lists out difference in the table in two DBs . |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2010-09-09 : 02:56:11
|
| There are products like sqlcompare by redhat for this. I've never used it myself though.Or else, You could write an SP by selecting tables, columns,..(whatever else you need) from the 2 databases and compare the 2 result sets- Shouldn't be that hard. Why don't you start with the sp and post whatever you have- We'll add/delete to it basis that. You can get help by googling for sp_comapredb as well. |
|
|
|
turbo
Starting Member
19 Posts |
Posted - 2010-09-13 : 03:40:00
|
| thks |
|
|
|
|
|
|
compare tables in two