Oracle SQL Developer: Single Object Compare

thatjeffsmith SQL Developer 16 Comments

Tell Others About This Story:

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:

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

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.

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.

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.

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.

Tell Others About This Story:

Comments 16

    1. thatjeffsmith Post
      Author
      1. Feature request:
        Please add this. My dream is to compare the data in two tables with an identical schema, and have UPDATE or INSERT statements auto-generated same way this tool auto-generates ALTERs.

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
  1. How do you compare two tables in two different schemas in the same database? When I select the same connection for the source and destination connections on step 1 of the Diff wizard and select Next the error message “Source and Destination are same Database nothing to Diff” is displayed.

    1. thatjeffsmith Post
      Author
  2. This is a really simple and easy to understand article. I have installed plsql developer and I am not sure how to compare objects in this tool. If you have any idea, can you please write a post on this. Meanwhile I will install sql developer and try this feature.

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *