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 |
|
Slj
Starting Member
1 Post |
 Posted - 2010-03-30 : 10:27:03
|
Migrating tables from SQL Server 2000 to SQL Server 2008When I used the migration wizard in 2008-Management Studio for importing tables (with data) from SQL 2000 to SQL 2008, the keys (PK, FK) and other restrictions (identity insert) did not get copied over. Any suggestions?Thanks! |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-30 : 12:18:23
|
| Backup the DB and Restore under SQL 2008 ?Hints and Tips on migrating to SQL 2008 here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
 |
|
|
|
|
|
Migrating