SQL Server export File/table schema and data operation steps _mssql

Many friends ask the SQL Server database "Generate script" to export only the SQL scripts for the database, while the table and table data still do not come out. Very simple, look at the tutorial:

Note: I use the SQLServer2008 here, the other version should be similar.

First, select the database –> task you want to export –> build script (or in the task have generate script this option, look for what can be found!) ）

Second, the "Build and publish Scripts" window appears, click Next

Third, choose the database object to script, all export Select the first, if you want to export some of the data tick the second one is good

Click on the "Advanced" button (emphasis) after this screen appears.

V. "Types of data to script" correspondence: "Schemas and data"

Six, determine, next, next, accomplished.