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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-22 : 12:21:16
|
| Dear All,please correct me if i'm going in a wrong way.i need to upgrade my sql server2000 ent to 2005 standard edition.1) i'm installing seperatly on the same server, and later i'l stop the service of sql server 2000 then detach the databases later attach in sqlserver 2005, then change the compatiability level to 90.now my doubt is can i install 2005 with the same instance name of 2000?after finishing the installation, is there anything to change at application or automatically it connects to 2005 instance? please let me knowthank you very muchArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-22 : 12:39:32
|
| If you are going from SQL 2000 to 2005, It is better to go with Backup/Restore than Detach/Attach which is safer. You can't have same instance name in same server but you can if you are upgrading to new server |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-22 : 17:21:56
|
| Or perform in-place upgrade. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-06-23 : 01:46:05
|
| As well as moving the databases you might have to also script the sql 2000 users and run the script on your new 2005Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
way of upgradation