Oracle SQL Developer PL/SQL Packages Trick – Synchronize!

thatjeffsmith SQL Developer 3 Comments

You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common. And as a child of the 80’s television, my brain has been properly warped. So here is your Christmas themed SQL Developer ‘trick.’ Every look under the tree, and your first reaction is to be a little disappointed in …

How to Synch your Oracle SQL Developer Data Model to a Different Database

thatjeffsmith SQL Developer 5 Comments

First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different database and generate an ALTER …