Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL2005 to SQL 2005 upgrade

Status
Not open for further replies.

j252ewv

Programmer
Jul 2, 2008
43
GB

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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top