"MS SQL" merges multiple databases into a new database

Original: "MS SQL" merges multiple databases into a new database

In response to work requirements, two databases need to be consolidated into one library:

When you first use the import data, export data, and copy database three tools, the effect is not achieved.

Later, using "Build Script" to execute, success! The steps are as follows:

1. Create a new blank library, Scm_kqyy:

2. Select the database to merge with materials:

3, here is not table, direct next:

4, according to the need to choose: table, stored procedures, users, synonyms.

5, press set, Next:

6. Next Step:

7. Click the "Finish" button:

8, the appearance of the post-generated script:

9. Change the database name:

10, the SSM database operation mode is the same as "materials", the reference step 2~9; This is not the case.

11, complete. the only regret is that the data need to be merged in other ways, and do not know how to get together.

"MS SQL" merges multiple databases into a new database