Communicating Between remote Servers...

[MarkButler]

I have a local production server, and a web server at a remote ISP connected via a VPN. Both servers are running MS SQL 2000. I wish to do an extract of data on the production server and update it to the web server daily. The web server only gets a subset of the information on the production server.

I know I can't be the first to need this so what I am searching for is the best way to accomplish this. Do I refresh the web server daily (about 500MB of data)? Should I send each table with an indicator as to Add/Change/Delete?

Any suggestions would be appreciated.

TIA, Mark

 

[impulse24]

I would create a dts package, that runs the extraction of the specific tables, and then updates the remote server, and schedule the package to run whenever you want.