Database comparison Series 1-data comparison

Source: Internet
Author: User

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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.