I have two databases, one local and one on a server that I access
via VPN.

I need to ocasionally synch the two databases. I am able to enter
data locally when I'm "on the road" and when I return to the office
I want to be able to make sure that the data I entered while I was
away gets inserted into the one stored at the office.

Every table has a PK calle Surrogate and they are not unique between
DBs, meaning the Task table in remote DB could have the same values as
the Task table in the local DB.

How has this normally been handled via DTS?

What are the "gotchas" and how would I build this package?

I intend to store this package on the remote server and run it locally
from a Delphi application via COM.

Hi...

You may try replication service...this can send data to target DB..

If you want DTS ...maybe you can schedule copy of tables, but with option of
append, this writes data from the local table to the server table...but, may
be duplicate rows..


"The Cleaning Wonder Boy" wrote:

Using the DTS solution below would just append all records to the
destination table, so data would be duplicated every time the package ran.
You would have to set up a check to make sure you were only propogating data
that doesn't already exist, and propogating data that has been updated or
deleted since the last sync.
Very doable, but difficult and not nessicary.

As Guadalupe Nava said, Replication is exactly what you are looking for, and
will save you much hassle in the future.


--
Simon Worth


"Guadalupe Nava" <GuadalupeNava (AT) discussions (DOT) microsoft.com> wrote