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 |
|
CharlesWhiteman
Starting Member
4 Posts |
 Posted - 2007-05-14 : 11:25:29
|
| Hello all, i am a new member here and just have one question at the moment and i am also new to SQL2005.If i wanted to sites to have their own instance of SQL Server 2005 for local connection respectively but those instances syncronise so that they update to be the same, what would be the correct way to achieve this? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-14 : 11:54:56
|
| Use replication (peer to peer, merge, or transactional replication. Depends on business requirement). |
 |
|
|
CharlesWhiteman
Starting Member
4 Posts |
Posted - 2007-05-14 : 16:29:53
|
| Thanks for the reply. i will research. |
|
|
|
|
|
|
SQL in Multiple sites