sgujjar
asked on
Sync two SQL Servers
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.