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 |
|
akafritz
Starting Member
1 Post |
 Posted - 2007-07-12 : 18:36:50
|
| I have two databases identical in structure but with different data (staging database and a production database). There is a bunch of data in the staging database that needs to be moved to the production database. The data is in two tables and a foreign key link exists between them. The ID's in the tables of both databases started with '1' and started incrementing, so if I import all the data into production, there will be duplicate ID's. Is there an easy way to combine these tables? I'm not really a dba, but familiar enough with sql from an admin standpoint. Thanks for any advice |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-13 : 18:44:35
|
| Exclude indentity column, sql will generate new id on target table. |
 |
|
|
|
|
|
import data