ThatJeffSmith

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

First a couple of quick notes:

So the challenge presnted is: who do I compare my model against a different database and generate an ALTER script?

The answer is easy:

Upgrade to version 3.3 of Oracle SQL Developer Data Modeler

When you use the Synchronize feature in version 3.3, you get a new dialog:

New for version 3.3 - choose a different connection for syncs!

New for version 3.3 – choose a different connection for syncs!

Once chosen, we’ll connect to do the compare as usual.

If you’re not using the stand alone modeler, and are using the modeler inside of Oracle SQL Developer, you’ll need to use Help > Check for Updates to get access to version 3.3 of the modeler.