Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiran
Starting Member
30 Posts |
 Posted - 2004-09-07 : 17:56:31
|
| I have to the following data synchronization task using DTS. Can anybody help me thru the steps please.Source DB: DB1Source Table: ProductColumns:RowIdNameDestination DB: DB2Destination Table: ProductColumns:Product_idProduct_NameSource_RowIDThese two databases are not identical and need to sychronize data.How do I create the DTS Package1) To update the Destination table with the new products added2) To delete the rows that were deleted in the source3) Update Product name if changed in the source db with the help of rowidthanks in advance.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-07 : 18:00:17
|
| Why not use replication instead?Tara |
 |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-09-08 : 01:50:01
|
| replication is the way to go. If they are the same server, you might try triggers.Hemanth GorijalaBI Architect / DBA |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-09-08 : 12:51:33
|
| I will go for merge replication...------------------------I think, therefore I am |
|
|
|
|
|
|
DTS Help