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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-04-27 : 07:09:13
|
| I have a two catalogs on a server cata, and catb. Cata has two tablesorders, parties these tables also existin catb.Catb has many more tables and functionality.Cata gets updated by production data every hour and then datais pushed to catb.I am using a delete all records in catb and then insert * from cata.This is clunky and it causes issues.Is there a way that anyone suggests to update catb with any new data and insert any completely new rows instead of doing the massdelete mass insert.Thanks in advance.slow down to move faster... |
|
|
|
|
|
merging two catalogs