469,636 Members | 1,952 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,636 developers. It's quick & easy.

SQL Server Engine Downgrade

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
Aug 13 '08 #1
1 2787
(kb*******@gmail.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, es****@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/prodinf...ons/books.mspx

Aug 13 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by joshsackett | last post: by
1 post views Thread by Pantelis Krikis | last post: by
4 posts views Thread by Hyo-Han Kim | last post: by
2 posts views Thread by heidi.mu | last post: by
reply views Thread by Eric | last post: by
7 posts views Thread by Sharon | last post: by
5 posts views Thread by incrediblesuperdude | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.