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.

Click on the following links for:

How to install Oracle SQL Developer on Windows 10

Create Oracle SQL Developer connection

 

Compare Database Schema Difference 

 

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

 

052117_2102_Howtocompar1 How to compare two oracle database schemas in SQL Developer  Database Diff

 

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

 

052117_2102_Howtocompar2 How to compare two oracle database schemas in SQL Developer  Database Diff

 

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

 

052117_2102_Howtocompar3 How to compare two oracle database schemas in SQL Developer  Database Diff

 

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

 

052117_2102_Howtocompar4 How to compare two oracle database schemas in SQL Developer  Database Diff

 

5. Click Finish to start the comparison

 

052117_2102_Howtocompar5 How to compare two oracle database schemas in SQL Developer  Database Diff

 

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

 

052117_2102_Howtocompar6 How to compare two oracle database schemas in SQL Developer  Database Diff

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 from Source. That’s it. 

 

052117_2102_Howtocompar7 How to compare two oracle database schemas in SQL Developer  Database Diff

 

 

govindan How to compare two oracle database schemas in SQL Developer  Database Diff
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to compare two oracle database schemas in SQL Developer  Database Diff
Connect me
By | 2017-05-21T16:54:34+00:00 May 21st, 2017|Categories: Oracle|Tags: , , |0 Comments
Like us on Facebook.
Connect!