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 |
|
ssiss
Starting Member
10 Posts |
 Posted - 2008-09-08 : 16:38:36
|
| I need to load data into new datbase from different database. I cant do it in one go, becasue of Refrential integrity issue. I think I need to break relation ship in all of the tables first then load data table by table and reestablish relation again. Is there any script to do this automatically |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-09-08 : 16:43:10
|
| Maybe I'm missing something, but why not just load the tables in the proper order so you can let the database maintain referential integrity? |
 |
|
|
|
|
|
Breaking the relationship in table