I'll soon be installing an ASP application on our ISP web server that accesses a MSSQL DB also residing on the web server. Our vendors will be posting and updating data on this DB that I need to replicate back on our local version of MSSQL DB that in turn will update another MSSQL DB once vendor updates have been validated.
In other words, very "hairy" setup where things can go wrong fast if data changes aren't replicated and updated in a timely manner.
Anyway, it's relatively easy to setup replication between MSSQL servers "within" LAN/WAN (trusted connection) but can I setup and schedule replication between MSSQL servers through the Internet between our ISP and local MSSQL? What issues are involved and are there any hurdles I should know and solve? TIA.
It's "my" world. You're just living in it.