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 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:
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.