There’s a nasty rumor going around that you can’t compare database objects and/or code in Oracle SQL Developer. So let’s put that to bed right now. First, here’s how to compare:
PL/SQL to PL/SQL or a SQL statement to another SQL statement
So now that that’s settled, why don’t we take a look at how to compare a single table, to another table – whether it’s in the same database or a different database.
Database Diff
There’s no additional licensing requirement here. If you have SQL Developer, you can use this feature.
if you’re going to compare 1 table to another, make sure you ONLY have ‘tables’ checked
And then, use this dialog to select your table(s):
Move over the object(s) you want to compare over to the right hand side.
And now we can move onto the results.
The differences, side-by-side, and the script to make B look like A
Common lines with differences are highlighted in blue, new lines are highlighted in red.
So that’s why they are different, but here’s the script to synch up the differences:
Read the script, TEST the script, apply the script.
And that’s it. Well, that’s mostly it. If you have questions about how to compare a database object in a schema you don’t have the login information for, read this post next.
