1. Story background

One iteration came to an end and was submitted to user testing. The system administrator initialized some data in the test environment, and then when it went online, the system administrator went to the formal environment to initialize it. These data, but this time there is too much data, I said once: "Why do you need to initialize twice?"

What you said makes sense! However, Navicat only provides direct data synchronization function, and does not provide the function of generating sql statements. The data is updated and the sql cannot be seen. I feel a bit uneasy. I found dbForge Data Compare

2. Usage tutorial

　1. First create two new tables in the database and initialize some data

Database A, table structure & data:

Database B, table structure & data:

　2. Download The above link opens the software

3. Create a new connection and select the table to compare data in mapping

4. In this step, you can see the data differences between the two databases. Click the green arrow to synchronize the data with one click. However, we still want to see the sql, Click "Synchronize" in the upper right corner of the page to generate a sql statement

In this way we can get the sql statement of the database difference data and submit it directly to the operator Dimension’s official environment database has been updated!

3.Finalization

After writing this operation, I felt it was too simple. It was entirely for the Amway Devart software. . . .

There should be applause here

The above is the detailed content of Database data comparison automatically generates sql tutorial sharing. For more information, please follow other related articles on the PHP Chinese website!