Synchronize a remote and local database - MAYBE???
I am having trouble figuring this out to be efficient - perhaps someone can assist me.
I have a SQL Server 2000 database that is hosted on a remote server that handles all of my transactions. I can access this fine - everything is cool. But I am also running SQL Server 2000 locally and want a local database copy to be synchronized with the remote (remote being the source of course). How can this be done? I want the local backup to be as live as possible but even if I had to set it up to synchronize every couple of hours that would be fine too.
Also - once this is accomplished (or if), will my local backup copy automatically make appropriate changes such as added/removed tables and columns if the remote source db has changed?
If there is one place to find the answer its here baby!