Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If an 2005 sql express database has been upgraded to 2008 (it was attached on a machine with 2008) , is it still possible to use that same database on a different computer with with sql express 2005?

share|improve this question

Definitely not. If you do need to go backwards, you'll have to use the Data Export Wizard.

share|improve this answer

No, the easiest to do is to use the wizards in Management Studio (under Tasks for a DB) and SCRIPT the entire database, making sure to specify compatibility with the earlier version. This will create a (probably huge) SQL script file which can be run on the SQL 2005 instance. It's probably more straightforward to update the other PC to SQL 2008 Express.

share|improve this answer

Almost certainly not.

Generally speaking restoring a database onto a newer version of SQL server works, and affected structures are altered as needed, but the same can not be done in reverse (newer versions do not support downgrading, and older ones would not know how to alter the newer backup file).

share|improve this answer

No. When you restore a database to a newer version of SQL Server (not including service packs and hotfixes), it updates the internal structure of the database files to match the structure used on the newer version. Once converted, there is no way to reverse it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.