We have a sql server database inside our firewall.
This allows us to take customer details and orders over the phone.
We have written a vb.net application that allows users to batch print orders which are then fulfilled in-house.
we now want to set up a web site that sells our products over the web.
We plan to operate a separate sql server on the web server that logs customer details and orders.
Once a day, out of hours, we want to import all records (through our firewall) into our in-house sql server.
In fact the data exchange needs to run both ways. When new products are added on the in-house system, we want to automatically add them on the web server.
So I guess Customer and order details come down from the web server, Products are uploaded from the in-house server to the web server.
How can we securely connect one server to the other?