Migrate database to a lower version

It is not supported to downgrade a Microsoft SQL Server by using the detach/attach or backup methods. However, it it possible to script data from the upgraded database and then import it into a new database in the lower version of SQL Server. A good description of this can be found on the following page:
http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

Advertisements