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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2011-03-23 : 08:57:45
|
| Hi,Could anyone tell me the best way/optimized way to synchup some of the tables from production to development environment in SQL Server 2005 on a daily basis, which will be scheduled as a job.One way is to create link server and populate the data.Creating a link server is ruled out in my case, so what other ways where we can synch up the data (truncate and load). Even, If I do with SSIS Jobs there are multiple tables to be synchup and the performance will be a hit. Your thought is highly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Synch up between two servers.