SQL Server Engine Downgrade

[kb0odu.tj@gmail.com]

We currently have a database server installed with SQL Server 2005.
We're preparing for an application upgrade / conversion that is
currently on another database server under SQL Server 2000. Now we
are being told by the application vendor that the application will not
work with SQL Server 2005.

What are the issues with downgrading our SQL Server 2005 to SQL Server
2000? Can we just do an uninstall of SQL Server 2005 and install SQL
Server 2000?

Tim

[Erland Sommarskog]

Re: SQL Server Engine Downgrade

(kb0odu.tj@gmai l.com) writes:

We currently have a database server installed with SQL Server 2005.
We're preparing for an application upgrade / conversion that is
currently on another database server under SQL Server 2000. Now we
are being told by the application vendor that the application will not
work with SQL Server 2005.
>
What are the issues with downgrading our SQL Server 2005 to SQL Server
2000? Can we just do an uninstall of SQL Server 2005 and install SQL
Server 2000?

As long as there are no databases you want to move from SQL 2005 to
SQL 2000, there is no issue. If you need to move databases as well,
you will have to script them.

SQL 2005 have soon been out for three years, and SQL 2008 shipped last
week. SQL 2000 mainstream support has ended. Doesn't this vendor feel
ashamed?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.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/prodinf...ons/books.mspx