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 |
|
gs_ham
Starting Member
1 Post |
 Posted - 2009-06-16 : 12:39:21
|
| I have a Sql 2005 DB at a remote site connected via T1. Here I have a Sql 2008 DB. I am trying to "push" data from our main 2008 db down to the Sql 2005 db. Although the data is mainly lookup data and not expected to change very much, I would still like the changes pushed down to Sql 2005 as they happen. Data only needs to be synched one way. My first impulse was to link the servers and add some triggers that would update the linked 2005 server. Is this a common solution? Would Replication be better suited? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-16 : 13:01:47
|
| I would recommend replication..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Linked Servers vs Replication