[Original] How SQL Server exports data as an SQL script

Source: Internet
Author: User
Recently, many people asked a question about how to export the database and data in MSSQLServer as SQL scripts. The main question is MSSQLServer2000 and 2005, because the manager of 2008 already has this function, 2000 and 2005 do not exist. I checked on the Internet and used commands. Here I will introduce a relatively simple and easy-to-use method:

Recently, many people asked a question about how to export the database and data in MSSQLServer as SQL scripts. The main question is MSSQLServer2000 and 2005, because the manager of 2008 already has this function, 2000 and 2005 do not exist. I checked on the Internet and used commands. Here I will introduce a relatively simple and easy-to-use method:

Recently, many people asked a question:MSSQLServer database and data in it are exported as SQL scriptsThe main questions are MSSQLServer2000 and 2005, because the 2008 manager already has this function, and 2000 and 2005 do not.

I checked on the Internet and used commands. Here is a relatively simple and easy operation method:

A tool named Navicat Premium is required.

Navicat Premium is a powerful database management tool that can be connected to MySQL, SQLite, Oracle SQLSERVER, PostgreSQL, and so on. It has a registration code online, download it and download it to the cracked version. Only learning is supported. Please support genuine version !!!!

Start with the question:

1. Use Navicat Premium to connect to your SQLSERVER database. If it is not connected, please Baidu;

2. After the connection is successful, open the connection and you will see all your SQLSERVER databases;

3. Right-click the database to export and choose data transmission;

4. For settings, see:

5: Click start. The log is displayed. Close the log.

Finally, go to the C: \ Users \ Administrator \ Desktop \ directory and find the exported MySQL script. SQL file.

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.