Generate Alter Scripts with Toad Data Modeler

Toad Data Modeler
1

In am in a CI/CD environment where drop and create scripts are not acceptable, particularly for tables. I need to generate DDL based on differences between two model versions. The Model Comparison report identifies the changes, but I want Toad Data Modeler to build a script that implements those differences, such as:

  • Add, modify or delete columns, keys, indexes, etc.
  • Drop objects that no longer exist in the current model

Is this possible? Everything I have seen indicates Toad only supports Drop and Create.

If you think you saw this before, you did. I accidentally created this question under "Toad for Oracle." This is not a toad for Oracle question.

Thank you.

2

It is possible. I use it every day.

3

@ciexpert: Please elaborate so I can learn how to generate the alter table scripts. Thank you.

4

I found the solution: Model -> Generate Change Script -> Run