SQL Server 2008 How to export data to a SQL script file _mssql2008

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

See the operation diagram below.

1. Use SQL Server Management Studio 2008 to connect to the database.

2. Select the database node that you want to export data to, click the right mouse button, select "Task"-> "Generate Script" in the menu, as shown in figure:

3. In the pop-up interface, point 2 times "next" into the diagram interface, "Write the Footsteps of data" to true.

4. Other action points "next" can be. The following figure is the last generated SQL script:

NOTE: The SQL Server Management Studio 2008must be used here, and no other version is available.

SQL Server 2008 Exports data as a script

Starting with SQL SERVER 2008, we can easily export data scripts without resorting to stored procedures

(But there is a slight difference in the process of exporting scripts for SQL Server 2012 and SQL Server 2008)


Begin:

Select database to operate--right--"task---" Generate script


And then the next step >>


This data script is changed to true, which means that the data in the table is also generated by SQL script

And then the next step >>


Here you can choose your own and then the next step >>


And then the next step >>


Here you choose the Save path for the script, and then the next step >> next >> finish it.

Related Article

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: info-contact@alibabacloud.com 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.