How to compare two Oracle database schemas in SQL Developer – Database Diff 

Oracle Sql Developer provides a feature called Database Diff to compare two different schemas. Using this, we can compare the tables, views, synonyms, triggers between two schemas. You need to establish a database connection before proceeding the comparison. This section, I have compared two different database schemas, one is older version of schema and another is later one.

Compare Database Schema Difference 

1. Open SQLDeveloper >> Click on Tools >> Database Diff

2. Select the database connections in Source Connection & Destination Connection

3. Toggle on the options you want to compare. If you want to compare only tables between the schema then toggle of remaining options except for table

4. Click on button Lookup to list all the tables/views etc. and move it to right. SQL Developer will compare only the objects in the right

5. Click Finish to start the comparison

6. The SQL Developer Comparing progress bar will show the progress of objects it compared

7. Once it was done, it will show the differences between the schemas. Select the object to see the what is differed in the destination connection. That’s it. 

Click on the following links for:

How to install Oracle Sql Developer on Windows 10

Create Oracle SQL Developer connection