Graphics and text tutorial MSSQLServer database export to another database method _mssql

The following is an illustrated way to introduce the method of exporting MSSQLSERVER database to another database, please see below for details.

1. Prepare the source database, locate the database you want to export, right-click the task and select Export Data

2. Set source database Information

3. Set the target database, exported to the database information

4. Set the data to be replicated

There are two main classes, one is to copy some tables directly, and the other is to specify the data according to the SQL query

Copy some tables select the first item, then select the table you want to copy, and then click the "Finish" button to start copying the data from the source database to the target database

If you choose the second one, you need to provide SQL to get the replicated dataset

The above is a small set to introduce the MSSQLServer database exported to another database method, I hope you like.