Shulou(Shulou.com)05/31 Report--

MS 2008 database conversion to 2000 version of the method is what, for this problem, this article describes the corresponding analysis and solution in detail, hoping to help more want to solve this problem of small partners to find a simpler and easier way.

My computer originally had a database of 2000, but last year I installed a new database of 2005 on that computer. Recently I bought a new computer and installed a database 2008 attached to it from a database on my old computer. Finished the project, the database to space, space database is 2000, error said my database is 2005 now I want to convert my database to 2000, but my 2008 database script wizard which did not convert to 2000 this option, 2005 version and not attached.

About this problem, the Internet to consult the net friend, real people more power, give a series of answers, the following is for everyone to organize the content, hope to help you solve SQL Server database from the high version to the low version of the problem.

The solution given by netizen DBA_Huangzj:

Drag the script to the query analyzer interface of 2000, and then click Run. I don't know before 2000, but all SQL Server versions F5 since 2000 mean run... You haven't used SQL Server, have you? After it is created.

Follow the screenshot of that step in my article to open the import and export tool, and then click all the way down, pay attention to fill in the instance name of 2000 in the [target server], and then go to this place to select all, and then click Next.

Point completed.

And then it's basically done.

But note here, because you directly dropped from 2008 to 2000, the span is very large, and 2000~2005 is a large span, many compatibility problems, so do not rule out that you will report errors when generating scripts and guide data (and the possibility is relatively high!), If so, manually remove the ones that report errors, write them down, continue running the ones that do not report errors, and manually create the ones that report errors.

To add a sentence, the safer way is to generate the table first when generating the script, that is, select the table in [Select Object] in step 2, and then generate the script. If it succeeds, then generate other things such as stored procedures.

About MS 2008 database conversion to 2000 version of the method is what the answer to the problem is shared here, I hope the above content can be of some help to everyone, if you still have a lot of doubts not solved, you can pay attention to the industry information channel to learn more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.