Networks

Ask something
Question Locked

How to upgrade from SQL 2000 to SQL 2005?

0 helpful
3 replies

by phatfield

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have database on SQL 2000 and I need to upgrade to 2005. I have upgraded server from Windows 2000 to 2003. No problems there, but not really sure how to do Sql upgrade. Do I need to uninstall 2000 first and then do a new install of 2005?

3 replies

by mohammad oweis

Just run the setup for SQL 2005, it will search for the old versions and do the upgrade.

But take a backup for the SQL server, because the upgrade process is irreversible.

There is a lot of changes between SQL 2000 and 2005, check if your applications can read the data from SQL 2005 DB, or has support for SQL 2005

This discussion is closed to new replies.