Solutions for attaching high-version database data to the low-version database

Source: Internet
Author: User

First, find a computer with SQL Server 2008 and attach your database file to this computer.
After the attachment succeeds, in the SSMs Object Explorer window, right-click the database you just attached, select Task > Build Script ..., and the Script Wizard dialog box appears.
Click "Next".
In the Select Database dialog box, select the database you just attached, and tick the bottom "script all objects in the selected database". Click Next.
In the Select Script Options dialog box, you also need to modify the following several options:
1). " The script that writes the data ", set to" True "; (SQL2005 does not have this option, so to find a computer equipped with SQL2008, how easy Ah, save the data import and export trouble)
2). " Write trigger Script ", set to" True ";
3). " Write the script to create the database ", set to" True ";
4). " Script The server version, select SQL Server 2005;(If it is the SQL2000 you want to use, choose SQL Server 2000)
The above 4 options are very recommended for this setting, the other options on their own to do, others generally do not have to change. Click Next.
In the Output Options dialog box, select Save script to file, other default, point to next.
Click Finish.
Click Close.
Then create a database in the server with the same name, and "new query", copy the code just generated, comment out the first line of the path, execute. We found that a new database has been established in SQL2005.

Solutions for attaching high-version database data to the low-version database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.