PLSQL Developer can synchronize table structures and table data of different databases.

PLSQL Developer can synchronize table structures and table data of different databases.

The Tools Options in the PLSQL Developer menu contain the Compare User Objects and Compare Table Data functions.

1. Tools --> compare user objects

This function is used to compare objects owned by different users (including tables, sequence, function, procedure, and view) and generate SQL scripts for synchronization differences. You can execute this script, the object structure of two users can be synchronized. Of course, you can select one or more objects for comparison.

Procedure:
1. Select a comparison object for the sample database
2. Select the Target database (Target Session...), that is, the database to be modified and synchronized
3. Click the Compare button.
4. On the Differences tab, click each object to view the SQL statement for eliminating the difference, and click Apply SQL in Target Session to execute
5. Click Show Differences to display the Differences.
 

2. Tools --> compare table data

This function is used to compare the data consistency in some tables and automatically generate an SQL script for synchronization difference. You can execute this script, you can synchronize the data between the Compare object and the compared object.

Procedure:
1. Select a comparison table for the sample database
2. Select the Target database (Target Session...), that is, the database to be modified and synchronized
3. Click the Compare button.
4. On the Differences tab, click each table to view the SQL statements for eliminating the difference.
5. Click Apply SQL in Target Session to execute

Note: Updates other fields for records with the same primary key value.

How to Use plsql developer to export the Oracle table structure

Tools-> export user objects
Export table structure
 
How can I view all tables of a database after pl/SQL Developer connects to the database?

There is an Object browser under the menu Tools to check it (if it has been checked, you don't have to worry about it), and then there is an Objects window on the left of the IDE, with a tree structure diagram, you can find the Tables in it to show all the Tables. By default, the displayed Tables include the system Tables and Tables in other schemas permitted by permissions. If you do not want to see the Tables, you only need to change All objects (drop-down box) on the top of the tree chart to My objects to view your own table.