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!

Thanks.

Answer: SQL Server Replication

Pls check it http://www.cryer.co.uk/brian/sqlserv...eplication.htm for details.



Cheers,
Pooja Falor

Thanks for the link -- however the host database that I want to synchronize has restrictions which do not allow me to do that. Their response to my problem was "due to security risk the function's accessible are only supported. You can use DTS to import and export"

So how can I set up some sort of automated function using DTS so that my local copy is updated at certain intervals?

No one has run into this same scenario before or can help? Pretty please with sugar on it?