Plsql developer to implement table structure and table data synchronization in different databases

The Plsql Developer Menu bar has compare User objects and compare Table data functionality under the Tools option.

One, Tools--Compare user objects

This feature is used to compare objects owned by different users (including table, sequence, function, procedure, view, etc.) and generate SQL scripts that synchronize the differences, and the user can maintain synchronization of the object structure of two users by executing the script. Of course you can also select an object or multiple objects to compare.

Operation Steps:
1. Select a comparison object for the sample library
2. Select the target library (destination Session). ), which is the library that needs to be modified and synchronized
3. Click the Compare button
4. On the Differences tab, click each object to see the SQL that eliminates the differences, click Apply SQL in Target session to execute
5. Click the Show Differences button to show the specific differences

Ii. Tools--Compare table data

This feature is used to compare the consistency of data in some tables and automatically generate a SQL script that synchronizes the differences, which allows the user to keep the comparison object synchronized with the data in the object being compared, by executing the script.

Operation Steps:
1. Select a comparison table for the sample library
2. Select the target library (destination Session). ), which is the library that needs to be modified and synchronized
3. Click the Compare button
4. On the Differences tab, click each table to see the SQL that eliminates the differences
5. Click Apply SQL in Target session to execute

Note: The primary key record of the same value is updated (update) other fields.