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 |
|
TMDOSS
Starting Member
33 Posts |
 Posted - 2010-06-14 : 16:21:10
|
| I created 5 different Tables with relationship between all the tables in the test. Now I want to move all these 5 tables to Production.if I created the Tables with SQL Scripts and copy the data it failes becuase of the Identity column values. How can I move the tables with values with keys and identity values |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TMDOSS
Starting Member
33 Posts |
Posted - 2010-06-15 : 08:47:26
|
| Thanks. I already tried that, but the relationship doesn't carry over to the new database |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
copying Tables structure and Values to another DB