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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Sync two SQL servers across country

Author  Topic 

sean.sullivan
Starting Member

7 Posts

Posted - 2009-03-25 : 12:01:33
I have a custom access project tied to a SQL 2005 server. Another location across country would like to run the same app on their network but have the two databases remain up to date with each others information. What is the best method to use? Note, the internet connection can be flakey.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-03-25 : 14:51:11
try peer-peer replication..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-03-25 : 15:37:27
if the connection if flakey you could use a self made solution with service broker:
http://www.sqlteam.com/article/centralized-asynchronous-auditing-across-instances-and-servers-with-service-broker
i'm not familiar with peer to peer replication so i can't really give you any comparison.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!
Go to Top of Page
   

- Advertisement -