SQL Server R2 making database structure and data scripts

The database contains many tables and data, and sometimes you need to create a script to export the table structure along with the data

Here's how:

1. Right-click the database and select Tasks---> Generate script

2. According to the requirements, select the object to make the script, the general situation select "Table"

3. Select the script generation method, as required. Personal habits choose to generate to a new query window.

4. By default, only script for table structure is made. If necessary, click "Advanced", in which "Scripting data type" is selected "Structure and data"

And then all the way next.

SQL Server R2 making database structure and data scripts