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 to build a script that implements those differences, such as:
- Add, modify or delete columns, keys, indexes, etc.
- Drops objects that no longer exist in the current model
Is this possible? Everything I have seen indicates Toad only supports Drop and Create.