Detailed description of SQL Server database data import operations (figure)

Microsoft SQL Server Management Studio is a client tool for SQL SERVER. I don't know how the data is imported by everyone. I 've encountered it recently. This is mainly because you do not have the permissions of the remote database server. Instead, you need to test the conflict between the modified content and the old data. As the process changes, you must modify the data to adapt to new changes. Therefore, data in the real environment needs to be simulated in the test environment. At that time, it was funny to paste it into EXCEL and then copy it to the database. This method can also be used in general, but for some special characters, if they are directly pasted into the EXCEL file, they cannot be displayed normally, such as the bit field and DateTime field.

I wonder if you all know that Microsoft has provided us with the data import and export functions. The following describes how to directly paste the operation steps, because it is relatively simple, so there is no special need to explain. For more information, see:

 

The following is a simple description of the texture.Import DataFor example,Export dataFunction is similarImport DataIt's exactly the same. I don't know why I need to make two.

It is also explained that,Select the source from which to copy data, That is, set the source data, such as copying data from A to B, where the database of A is set.

Next, copy from A to B, that is, set the database of B.

Two methods are provided to select the data source to be copied. If A and B are of the same structure, select the first method, and choose the data source to be copied in A personalized manner.

Because the Demo database (A mentioned in the preceding example) only has one table, only one table is displayed. If there are multiple tables, it will be displayed. Select the table we want to copy.

Note: If the primary key of the table in Table A is auto-increasing, you need to remove the auto-increasing Mode of the table in Table B first. This is because copying from A to B is the replication of all fields, including self-increasing IDs. After the data is copied, the table in database B is changed to the auto-growth mode.