June 27, 2007 at 5:02 pm
hi new to this upgrade and migrating things...i am trying to upgrade my sql 2000 to sql 2005 dev.edition. should i install 2005 in same machine and do side my side upgrade or should i do backup and restore.
and also let me know in case i have 10 different servers and 200 user machine.
how should i upgrade all of them. should i install 2005 in all the 10 servers first. is there way to install all at a time. and how should i upgrade 2005 in all 200 user machine.
please let me know
thanks
June 27, 2007 at 8:35 pm
Hi Derek,
There are 2 types of upgrades you can perform namely,
inplace upgrade and side by side upgrade.....In inplace---the existing SQL 2000 will be replaced by SQL 2005,you need to run the upgrade advisor and identify the issues with upgrade and subsequently proceed with your upgrade.in side by side u can perform the backup of your sql 2000 dbs and restore them in 2005 or go with detach the dbs in 2000 and attach it in 2k5 else you have 1 more option with copy database wizard in sql 2005...
refer the following links....
[font="Verdana"]- Deepak[/font]
June 28, 2007 at 12:03 am
Derek,
Since you say that you are new i prefer you to follow the second method of doing a side by side upgrade than a inplace upgrade since that involves lot of complexity. Do a backup of the database and restore it in 2005 and change the compatability mode to 90 so that you will be able to use full advantage of 2005 features in the databases.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 2:14 pm
but i do have to install 2005 first on same server, but does this contrdicts if the same machine has two diff versionof servers. please let me know.
June 28, 2007 at 8:04 pm
Derek,u can have both 2k and 2k5 in the same server.since u had 2k already it wud have been a default instance,so u jus need to install 2k5 as a named instance.u can detach the db in 2k and attach the same in 2k5 or backup and restore......anything is fine....else if u want 2k5 as default instance u can even uninstall 2k and install 2k5 as default instance but ensure that u have latest full backup of all the 2k dbs b4 uninstalling it.
[font="Verdana"]- Deepak[/font]
July 1, 2007 at 8:11 pm
thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply