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 |
|
balaji_rcs
Starting Member
1 Post |
 Posted - 2007-10-12 : 03:21:11
|
| Hi Team, I've an doubt about the key relationships. Actually, Am going to migrate the DB data to another DB. In old DB, a lot of tables having the key relationships and I dont know about how to prioritize the table for insert query Script Generation. Can you clarify my doubts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-13 : 00:44:05
|
| Migrating parent table first, you can use diagram to find out relationship easily. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-13 : 10:27:29
|
| We query dbo.sysforeignkeys, in a loop, to work out the number of Parent/Child tables, and then create the Copy Order based on that.Kristen |
|
|
|
|
|
|
Database Migration