I am talking to a prospective client who has his WEB hosting done by another company.

He wants me to put up a SQL Server at the home office and send updates to the web database. It could be daily, or real time.

I was wondering what issues I am up agianst and what about firewalls?

My plan was to dts data out of his SBT system into the SQL Box nightly. (I'd only take changes done in the past 3 days) I now want to send a copy of these _TMP files to the web host. There they have to nke from their files what I sent them then insert the _temps. Is this a best way os is there a prettier solution that I am missing?

TIA

__Stephen