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