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 |
|
rucha3
Starting Member
7 Posts |
 Posted - 2008-03-15 : 10:08:16
|
| Hi all,i 'm looking to migrate sql server 2000 database to sql server 2005. Can i do it by detaching database in 2000 and attaching database in 2005. or can i do it using DTS package? Which is the best way to go for it? can anyone suggest me on this plz? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-15 : 10:27:23
|
You can do that, but there are other considerations as well. Below link will be helpful as it discusses migrating .. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84034
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-15 : 13:58:51
|
| Backup/Restore will be best option. If you do detach/attach method,by some mean if you can't attach to SQL 2005. You won't be able to attach back to SQL 2000. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-15 : 14:23:45
|
| sodeep is right. and when you restore the backup don't forget to change the database compatibility level to 90_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
rucha3
Starting Member
7 Posts |
Posted - 2008-03-16 : 19:22:44
|
| yeah thanks for help. backup and restore option worked in tht case. |
|
|
|
|
|
|
Question