Database comparison Series 1-data comparison

During the project process, the local data is often different from the server database data, but the data needs to be updated. If you copy the data directly, the efficiency and accuracy will be solved. Therefore, vs2010 has its own data comparison function. The following describes the data comparison function.

1. Select "data" in the vs2010 toolbar, and then select "new data comparison" in "data comparison"

2. Select the source database and target data

It is recommended that you select the "quantity of records to be compared" by default, so that you can see the table differences more conveniently.

3. Select "Next", select "table" and "try", and click "finish"

Fourth, we can see two pieces of data,The table names must be the same during comparison.To compare data.

The following figure shows the differences and similarities between the two tables in detail, as shown below:

Finally, select the data to be retained, add the data, and then select the vs shortcut toolbar to update the data to the target database.

The rest depends on the test. This section mainly describes data comparison. The next section describes the comparison of database structures. with structural changes, data can be better updated to the target database!