SQL Server - upgrade

Asked By john doe

20-Nov-09 12:42 PM

Is it possible to upgrade from Microsoft SQL Server 2000 Desktop Engine to
Microsoft SQL Server 2005?
Or can I run them both separate?
Please advise and thanks.

20-Nov-09 06:01 PM

john doe (johndoe@johndoe.com) writes:

Yes, according to this page:
http://msdn.microsoft.com/en-us/library/ms143393%28SQL.90%29.aspx
you can upgrade SQL 2000 MSDE to SQL 2005 Express or Workgroup Editions.


Yes, it is possible to run instances of SQL 2000, SQL 2005 and SQL 2008
on the same machine.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx