Can Sql 2005 Database be used by Sql 2000 server

Hi i am a newbie and an developer i have an issue the Development we are doing is on sql server 2005 and we are wanting to send this database for a front end team to develop fromt end and they are using sql server 2000 , will there be any problems with regarding to version. if there are problems what would be the way to provide them with the Data.Moving to the "Getting Started with SQL Server" forum from SSIS.|||I think you cannot restore sql 2005 in a sql 2000 server nor access it in sql 2000 but it can be done the other way round.........
|||

Dev2624 wrote:

Hi i am a newbie and an developer i have an issue the Development we are doing is on sql server 2005 and we are wanting to send this database for a front end team to develop fromt end and they are using sql server 2000 , will there be any problems with regarding to version. if there are problems what would be the way to provide them with the Data.

A better option is to give the developers SQL Server Express Advanced so you can use all the features in 2005 and moving database from development to testing is just moving either MDF/LDF or .BAK file. The reason is it takes a lot to move a SQL Server 2005 database to 2000 but it is easy to move a move 200 database to 2005. If you plan to use other subsystems of SQL Server for development a better choice for the developers is the under $50 no deployment restricted developer edition. Both the developer edition and the express editions comes locked down your developers need to enable all features needed to enable development. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx