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 |
|
ann
Posting Yak Master
220 Posts |
 Posted - 2008-07-23 : 17:53:57
|
| I am pretty new to 2005. We are migrating our sql server from 2000 to 2005.What is the best way to bring over the existing data from the old db to the new db while still keeping the ID's (Primary and foreign keys) intact?Is there something built in already in 2005 to help accomplish this task?Any input would be appreciated - Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2008-07-23 : 19:56:29
|
| So there is no issue with restoring the 2000 on the 2005? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-23 : 23:07:05
|
| Rebuild index after restoring, and change compatibility level to 90 if you fully tested already. |
|
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2008-07-24 : 12:40:38
|
| Where do you change the compatability level from? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-24 : 13:01:02
|
| In database properties-option |
|
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2008-07-24 : 13:07:18
|
| Thanks |
|
|
|
willow_mimi
Starting Member
14 Posts |
Posted - 2008-07-26 : 05:55:37
|
| actually there are 3 ways :1.backup-restore2.Copy database wizard3.detach-attachi recommend you use backup-restore if you work in a very large dataDont forget to use Upgrade advisor before you migrate(to check some issues that you should solve before you migrate)..this is very important :) u can read this to know more about sql 2005:http://myblog-sql.blogspot.comMurni Lim(Microsoft Trainer) |
|
|
|
|
|
|
Migrating from 2000 to 2005