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 |
|
malditacorazon
Starting Member
2 Posts |
 Posted - 2009-09-14 : 23:39:35
|
| Hi SQL Admin experts!I would like to ask with the problem that i've been encountered during our migration of data from SQL 2005 to SQL 2008.I observed that when we restored our data from SQL 2005 to SQL 2008, all the primary keys set is no longer defined as primary key field? I tried to edit some of the tables to check if the fields are still in tack then thats what happened. I dont have any idea about this or can the SQL SP1 can resolve this concern..? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-15 : 04:56:59
|
| Can you explain how you migrated the data?Did you backup the databases on SQL 2005, and then restore the .BAK files into SQL 2008?Or did you script the objects out on SQL 2005, and run into SQL 2008?Did you get any errors during the migration? |
 |
|
|
malditacorazon
Starting Member
2 Posts |
Posted - 2009-09-15 : 05:27:10
|
| Can you explain how you migrated the data?> I JUST SIMPLY USE THE RESTORE OPTION NOT THE SCRIPTS.Did you backup the databases on SQL 2005, and then restore the .BAK files into SQL 2008?> YESDid you get any errors during the migration?> NO ERROR MSG. |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-15 : 06:22:14
|
| What do you get when you run this in your database?select *from sys.indexeswhere is_primary_key = 1Do you still have the source database in SQL 2005? Can you run the above SELECT there too?And let us know the results. |
|
|
|
|
|
|
Primary Key Reference Disappear