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

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