SQL Server 2008r2 database files are imported into a SQL Server 2008 database

Recently, after the computer reinstall System, SQL Server 2008 was installed. When attaching the database file, the discovery cannot be attached and the wrong version is indicated. Remember, the original database version isSQL Server 2008R2. Low-version database management toolsyou cannot attach directly to a higher version of the database file. I haveTenseveral such database files need to be attached to the database management tools, Internet Baidu after some, did not find any special shortcut. Finally, we had to choose the first of these numbersThe library file is attached to one of the installedSQL Server 2008R2computer, and then export the data script to restore the database file through the data script toSQL Server 2008methods in the database management tool. When you export, you start to encounter a small problem, which leadsdata scripts cannot be exported, only database structure scripts can be exported. Several times before you understand it is the export option,SQL Server 2008R2with theSQL Server 2008The last Life option is not quite the same. After the adjustment, finally all successful export, and successfully restoredRecovery toSQL Server 2008in the database management tool.

The operation process is as follows: 650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356902_4860.png "style=" Border:none; "/>

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356903_8648.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356903_5738.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356904_2319.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356904_1000.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356921_6916.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356921_4830.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356922_5875.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384357309_4063.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356922_2870.png "style=" border:none; "/ >

650) this.width=650; "src=" Http://img.my.csdn.net/uploads/201311/13/1384356929_9285.png "style=" border:none; "/ >

This article is from the "Swaying Kite" blog, please be sure to keep this source http://pinzi.blog.51cto.com/4845903/1603838

SQL Server 2008r2 database files are imported into a SQL Server 2008 database