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 |
|
sateeshGenpact
Starting Member
6 Posts |
 Posted - 2012-11-06 : 12:46:34
|
| Hi Team,I am new to this forum, Greetings all!Issue:I have two tables in two different servers, one is on Prod and other one is on development with same column names and data types. I have to compare data, if there is any new or updated data populated in Prod that i have to push it to Development. kind of cross checking both the ways.Like that i have around 70 tables, is there anyway to achieve this in one package?Really appreciated for the help!Thanks in Advance!Sateesh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-06 : 13:47:36
|
| yep...you need separate data flows for each table though as the metadata is different------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2012-11-11 : 19:35:09
|
| Use a tool like Red Gate's SQL Data Compare. It's a whole lot easier than trying to grow your own.--Jeff Moden |
|
|
|
|
|
|
Compare Two tables data using SSIS must be Generic