SQL Server 2008 Export scripts and Data methods

Method One: The SQL Server2008 generated script can generate the export script.

1. Select the database node for which you want to export data, click the right mouse button, and select Tasks, Generate scripts from the menu.

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/3B/wKiom1R9EyqTyIATAAVQP_pwySw741.jpg "title=" Sql1.jpg "alt=" Wkiom1r9eyqtyiataavqp_pwysw741.jpg "/>

2. Select the database for which you want to edit the build script. Tick "Scripting all objects in the selected database." Then click Next, as

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/54/3A/wKioL1R9FNHj7UlwAATFCYqAzUA103.jpg "title=" Sql2.jpg "alt=" Wkiol1r9fnhj7ulwaatfcyqazua103.jpg "/>

3. In the popup screen, set the "Footstep of writing data" to True and click "Next".

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/54/3A/wKioL1R9FXaisSC5AAQQL6ojXyk423.jpg "title=" Sql3.jpg "alt=" Wkiol1r9fxaissc5aaqql6ojxyk423.jpg "/>

4. In the Output Options dialog box, I choose to save the script in the New Query window. You can also select Save script to file. then click Done.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/54/3B/wKiom1R9FbSiF8jnAAE41T_6FUE100.jpg "title=" Sql4.jpg "alt=" Wkiom1r9fbsif8jnaae41t_6fue100.jpg "/>

Method two, the database separation near the method

method Three, database backup and restore method

method Four, dynamic soft code generator generation

This article is from the "Program Ape" blog, please be sure to keep this source http://haihuiwei.blog.51cto.com/4789207/1585309

SQL Server 2008 Export scripts and Data methods