Graphic Tutorial: How to export the mssqlserver database to another database,

Source: Internet
Author: User
Tags mssqlserver

Graphic Tutorial: How to export the mssqlserver database to another database,

The following illustration shows how to export a mssqlserver database to another database. For more information, see the following.

1. Prepare the source database, find the database you want to export, right-click "task", and select "export data"


2. Set source database information

 

3. Set the target database and exported database information


4. Set the data to be copied

There are two main types: one is to directly copy some tables, and the other is to query the specified data based on SQL.

If you want to copy some tables, select the first item, and then select the table to be copied. Then, click "finish" To Start copying data from the source database to the target database.


If you select the second one, you need to provide SQL to obtain the copied dataset.


The above section describes how to export the mssqlserver database to another database.

Articles you may be interested in:
  • A Stored Procedure for viewing the space usage of the MSSQLServer database, SpaceUsed
  • How does mssqlserver restore ldf file data
  • Sample Code for MSSQLSERVER cross-server connection (Remote logon)
  • Example of how to start the mssqlserver service using the command line

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.