Database demotion-Reduced from SQL Server 2008 to 2005

The day before yesterday encountered a problem, is a database is SQL Server 2008, and the Platform database Library is 2005, need to attach 2008 of the database, tried a lot of ways, now feel the best way is to export the import method.

The first step is to create a new SQL Server 2005 database setup, notice that the file directory is modified, and do not conflict with 2008 of database files.

Create a new database in SQL Server 2005 using the generated script

The second step is to generate the database script, and note that you choose to script the server version to SQL Server 2005

All the options here are true.

Execute the script for the newly created library in the first step

The third step starts the import Export feature to import data from SQL Server 2008 into the newly created SQL Server 2005

So it's done.

In fact, the first and second steps are to create the database and database of tables, triggers, stored procedures and other objects, the third step is to copy the data over.

Database demotion-Reduced from SQL Server 2008 to 2005