Automatic Generation of SQL for database data comparison and Automatic Generation of SQL for comparison

Automatic Generation of SQL for database data comparison and Automatic Generation of SQL for comparison
1. Background

One iteration is coming to an end and is submitted to the user for testing. The system administrator starts some data in the test environment. Then, when the system administrator goes online, the system administrator starts the data in the environment, however, this time there was too much data and I said it once: "Why do we need to initialize it twice? "

What you said makes sense! However, Navicat only provides the direct Data synchronization function, does not provide the SQL statement generation function, updates Data, and does not see the SQL, it feels a bit uncertain, find the dbForge Data Compare

 

 

2. Tutorial

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

Database A, Table Structure & Data:

 

Database B, table structure & Data:

 

2. Download the above link to open the software

 

3. Create a connection and select the table for data comparison in mapping.

 

4. in this step, we can see the data difference between the two databases. Click the Green Arrow to synchronize data with one click. However, we still want to see SQL, click "Synchronize" in the upper-right corner of the page to generate an SQL statement.

 

In this way, we can get the SQL statement of the database differential data, and can directly submit it to the O & M to update the formal environment database!

 

3. Complete

After writing this operation, I thought it was too simple. It was entirely for the software of Amway devart ....

There should be applause here