Hi,

I've a databse that I want to synchronize between an DB2 and my SQL
Server.
I've already imported all my data from the DB2 database, but how could
I import and update the new data from the DB2 database ?

Should I use DTS ?
How could I create the DTS ?

Here are the information of my database :
Table : ETCITP
Unique identifier : CDDOSS (Varchar)
Update identifier : UPD_IDENT (Big Int)

Thank's for your help.

DTS can certainly do it but you will need to write the routines to handle
the sync. You can do this by clearing all the destination tables and then
repopulating or you can manage changes on the source and only take them
across.

For syncing it depends on latency that you can handle.

Nightly - I would probably do BACKUP/RESTORE
Hourly - Probably Log shipping
Anything else - Either DTS or Replication


Just some Ideas.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Denis" <anonymous (AT) discussions (DOT) microsoft.com> wrote

sounds like it's on the right track but...

Sounds OK.

Merge places restrictions on you (length of row, number of atttributes)

It also adds an extra attribute to the definition of the table as well which
may need to be planned for by your apps

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Denis" <anonymous (AT) discussions (DOT) microsoft.com> wrote

entering data into a local database, then when he gets to the office he
wants to "sync" with the main database there. When the data he's entered
has been approved they would like to then sync with a central database for
many offices.