Hi, have created my relational model from scratch using SQL Developer Data Modeler v 4.1.5, then have generated the DDL scripts and run those against the development database without any problem. Model and DB are in synch. Now I would like to add/change attributes of a particular table, therefore opened the Relational model and make the necessary changes but I am willing to generate the corresponding ALTER TABLE script. Have tried the option "Synchronize Data Dictionary Model" but does not recognize the tables already created on the database therefore it only generates the full CREATE script.
Have tried importing a data model from the DB, adding a new attribute to the table and then perform "Synchronize Data Dictionary Model". I was able to generate the ALTER table script. But it is not my current scenario. My Relational Model is not tight to a DB. How can I make it work?
Regards,
Mariano