method for converting MS SQL Server 2008 database to version 2000 _mssql

Anyway, my computer had a 2000 database, and last year I installed a 2005 database on that computer. Not long ago I bought a new computer, installed a database 2008 will be on the old computer on a database attached to 2008 above. After the project, the database to space, the spatial database is 2000, the error that my database is 2005 now I want to convert my database to 2000, but my 2008 Database Script Wizard does not turn to 2000 this option, The 2005 version is not attached.

On this issue, the Internet to ask netizens, real people more power, gave a series of answers, the following for everyone to tidy up the content, hoping to help you solve the SQL Server database from the high version of the downgrade to the lower version of the problem.

The solution that the Netizen Dba_huangzj gives:

Step 1:

Step 2:

Step 3: Drag the script to the 2000 Query Analyzer interface, then click Run, 2000 before I am not clear, but all SQL Server versions starting from 2000 F5 are running meaning .... You don't ever use SQL Server, do you? After the build is finished.

Step 4: Follow the screenshot of the step in my article to open the Import Export tool, and then always click on the "Target server" to fill out the 2000 instance name, and then go to this place select all, and then click Next.

Step 5: the point completes.

And then basically finished.

But note here, because you drop from 2008 to 2000, the span is very large, and 2000~2005 is a big leap, many problems of compatibility, so do not rule out your scripts and data to guide the time there will be errors (and more likely!) If there is, then you have to manually remove those errors, and then write down, continue to run the error, and finally manually create the error.

To add , the more secure approach is to generate the script, the gentleman into the table, that is, in step 2, "Select the object" where the table, and then generate the script, successful, and then generate other such as stored procedures.