Hi all
We have a small database that we host on our own local server. In order to
get the information into the database I have a VB program that collates the
information from a variety of sources and then over our local internal
network writes it to the database tables.
This information is then made available over the internet using the
companies broadband connection. In order to alleviate bandwidth issues we
are looking at paying for someone else to host the database.
What I am hoping to achieve is to keep the VB software, but during the night
upload the data to the remotely hosted SQL server using say a series of
update statements. Does anyone know if this is possible, and will SQL Server
look after the integratory of the data. Is there any issues with the
relatively low speed of then Internet as compared with a local network
environment. The amount of data we are looking at moving is very little,
some where in the region of a few hundred records per night split over about
10 tables.
many thanks
Andy