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
- P6 Progress Reporter completely integrated into P6 Team Member - August 15, 2017
- Primavera P6 Professional for EPPM Popup 16.2 : The appropriate industry for your organization has not yet been select in admin preferences - August 15, 2017
- Primavera P6 Background Job Error:Creating job Symon Failed to add Database Job, Check the settings table for valid interval values for dbms_scheduler - August 14, 2017