VS 2005 Professional and Sql 2000

[Paul]

My company recently upgraded the VS 2003 to VS 2005 Professional edition.
The VS 2005 Professional edition bundles with the Sql 2005 Developer
edition. However they decided not to upgrade the Sql 2000 Standard edition
to Sql 2005. How to deploy the Sql database to Sql 2000 if the project
(windows app or web app) is developed using VS 2005 Professional and Sql
2005 Developer edition? Can it be done? Also is it possible to install the
Sql 2005 Developer edition on a different computer other than the one has
the VS 2005 Professional installed on it? Or is it true VS 2005 only works
with Sql 2005?

 

[Christopher Reed]

You don't have to use SQL 2005. Just use 2000. SQL 2005 is not required to
be used.

 

[Leon Mayne]

My company recently upgraded the VS 2003 to VS 2005 Professional
edition. The VS 2005 Professional edition bundles with the Sql 2005
Developer edition. However they decided not to upgrade the Sql 2000
Standard edition to Sql 2005. How to deploy the Sql database to Sql
2000 if the project (windows app or web app) is developed using VS
2005 Professional and Sql 2005 Developer edition? Can it be done?
Also is it possible to install the Sql 2005 Developer edition on a
different computer other than the one has the VS 2005 Professional
installed on it? Or is it true VS 2005 only works with Sql 2005?

If your company is going to stick with SQL2000 then uninstall your
development copy of SQL2005 and install SQL2000 Developer Edition to develop
you applications on. You'll get far fewer problems!