SQL2005 to SQL 2005 upgrade

[j252ewv]

Can anyone tell me if there is an easy way to do this as I have done it a few times and it has proved to be a headache on each occasion.

This would make my life sooooooo muuuuch easier if there is a solution.

 

[j252ewv]

Sorry should be SQL 2000 to SQL 2005

 

[mrdenny]

You should just need to run the SQL 2005 installer on the SQL 2000 machine. If you are downgrading the edition when doing the upgrade you'll have problems, but if SQL 2005 edition edition is the same, or higher than the SQL 2000 edition it should go through without issue.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog