Monday, March 19, 2012

DTS and PKs/FKs

Hey guys, i have a db on my home dev server and When I used DTS to upload everything to the prod server, I noticed many FKs did not go thru. Some did, some didn't. I have about 77 tables a few with more than 5 FKs. Is there a reason for this? What's going on? Only thing I can think of, and I don't know much of the DTS internal process, is when the DTS was being performed and a table is created maybe the FK would not pass if the other table was not created? Does DTS create all the tables first, then performs the FKs or what? Any help will be grateful.

Thanks.Nevermind, i just found out that they ARE there. They just didn't show in EM until I opened the PK Table. then it showed in the FK table. Thanks.

No comments:

Post a Comment