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:
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 from Source. That’s it.
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 🙂
Latest posts by Govind
- How to add a catch block on Oracle BPEL - July 8, 2018
- How to Pass array of strings to a Field in Oracle BPEL - July 7, 2018
- Oracle BPEL For Each Activity Example - July 7, 2018