We help IT Professionals succeed at work.

Sync two SQL Servers

sgujjar
sgujjar asked
on
Medium Priority
397 Views
Last Modified: 2012-08-13
I have same databases on SQL Server 7.0 - one on 3rd party hosting service & another on my intranet. Both running on windows 2000.

I want to sync my database of same structures one on a hosting company server & another on my intranet. I want to have same data on both servers at any point of time. Ofcourse my sql server on intranet is connected to internet via DSL.

The hosting company sql server db is updated using a ASP application & my intranet sql server db is updated using a VB application continously.

Thanks for anyone answering
Comment
Watch Question

CERTIFIED EXPERT
Commented:
try merge replication. It is a bit involved, once you start pounding the conflicting data updates, that can be result of adjustments / changes to customer transactions by internal CRM but otherwise is working out of the box.
DXB
Commented:
Use merge replication (recommended for your situation). You may have to partition horizontally or vertically your data to avoid conflicts. For more information, plesae visit MSFT link below

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/replplan_0e5q.htm
sgujjar:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.