Remote hosted database - SQLServer 2000

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"aaj" <a.b@.c.com> wrote in message
news:40a09390$0$13571$afc38c87@.news.easynet.co.uk. ..
> 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

If you can connect to the server directly, then you can run INSERT/UPDATE
statements as you would normally. For a few hundred records (rows?) this
should work fine. I'm not sure what you mean by "looking after the integrity
of the data". If you want to ensure the data was not modified in
transmission, you can look at some sort of check digit or checksum.

If the amount of data grows, you might need to look at other options, such
as sending a file to the server via FTP, then loading it with bcp.exe or
DTS, but that would depend on the hosting provider's service.

Simon