March 2, 2007 at 1:36 am
Hi Guys,
Does anyone perhaps have any websites that would help with my investigation on migrating from 2000 - 2005.
We have to migrate one of our servers to 2005 and I need some advice on what to investigate.
Regards
March 2, 2007 at 2:20 am
There are several articles on SSC and some other good resources around the web..
Picking an edition: http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp
Feature sets: http://www.sqlservercentral.com/columnists/bBaliner/sql2000tosql2005wherehavealltheoldfeaturesgone.asp
Migration: http://www.sqlservercentral.com/columnists/vRainardi/migratingdatawarehousesystemstosqlserver2005.asp &
http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosqlserver2005.asp
An Upgrade handbook from Microsoft: http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Other than that I would google and read and first do the upgrade on a test machine before trying it on any production servers documenting exactly what you did at each stage - there are plenty of things which can go wrong but if you are careful it should all be fine.
HTH
- James
--
James Moore
Red Gate Software Ltd
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply