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 |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-01-18 : 06:33:56
|
| I have 2 SQL Server databases. 1 is the main DB and the other is a holding DB updated daily or weekly from an external source. I want to be able to compare the 2 DBs and determine which records in the holding DB need to either 1) be inserted into the main DB (i.e. New records)2) be deleted from the main DB (i.e. they no longer exist)3) they exist in both DBs so to Update the record in the main DB with the equivalent record in the holding DB.I've been led to believe that the best way to do this is by a data Transformation task using VB script but am unable to work out exactly how the VB script part should be written ?If anyone can recommend where to look, an example or just general advice it would be most appreciated.I have viewed many websites and books and can find no good references anywhere.Please helpPaul |
|
|
|
|
|
DTS Inserts, Updates, Deletes