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 |
|
Kzimmerman
Starting Member
8 Posts |
 Posted - 2004-09-17 : 12:40:05
|
Its your favorite non-DBA MIS lackey here  My question to you folks this afternoon, I've got 2 SQL2000 Server Db's which both are from Raisers Edge. The tables, which have the same feilds, but different data, need to be combined. Is there a command or tool which any of you would recommend using? I need to have this done on the ASAP, and im hesitant to touch anything that could cause loss without consulting an outside source first.By the way, please excuse any mis-naming of items... i'm not a DBA ;)(though i feel like i'm becoming one due to forced work on sql server)Ken ZimmermanMIS DeptAmerican Red Cross |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-18 : 07:09:03
|
| The default for DTS IMPORT is "Append". If you do it in Enterprise Manager when you get to the bit about which Source tables, and which destination table they should map to, there is a [...] (transform) button on the end - click that to see if it plans to drop the table first <BG>AFAIK the default is Keep any existing table; Append rows; Preserve identity numbers (if applicable for that table)However, IF you have duplicates on the PK for a given table then the import will fail (for that table only).You might want to RESTORE the DB into a temporary table, do a dress-rehersal, and then try it on the "Live" DBKristen |
 |
|
|
|
|
|
Merging 2 DB's without overwriting anything?