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 MVP http://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 |
 |
|
|
|
|