Hello there

I have two databases which are the same

One of them is on my local server

And the other one is on an internet server

Every 12:00 PM i would like to update the internet server with the changes
that were made on my local server

Can someone help to know how to connect between these two servers and how to
transfare the data?

any help would be useful

can you access this external database directly?
then replicate your changes using the replication capability of SQL Server
also you can use DTS to send new data to this external database by copying
new data (or new + old data) to the database

if you have a lot of data to transfert, and your bandwidth is low, then
export the data in a flatfiles, zip it, send it by FTP, then execute a
package on the remote server to unzip the file and load it in the database.

also you can create a backup of your local database, and restore it on the
external server.

But the choice of the solution depends of your requirements.

"Oded Kovach" <roygoldh (AT) hotmail (DOT) com> a écrit dans le message de news:
uJfLek%23kEHA.1152 (AT) TK2MSFTNGP11 (DOT) phx.gbl...