5 Replies Latest reply: Nov 4, 2009 2:00 AM by Philip Stoyanov-Oracle RSS

    Data Modeler: Generate Delta-Scripts against an existing schema

      Can I generate DDL-Scripts with "ALTER TABLE " - statements?

      For example: relational model and database are in synch. That means: Each Table of the db is stored in the data model of the Data Modeler.

      Now I need new columns in a table. I define these columns in the data-model and now I need a script with :

      ALTER TABLE my_table ADD (new_column DATE);

      In Oracle Designer it is more than easy to create such delta-scripts. But I found nothing similiar in the Data Modeler

      thanks in advance