I am temporarily replacing a colleague and I am now in charge with maintaining the team’s database model (and I am also a beginner with Toad Data Modeler).
I generated an alter script and I noticed the resulted file is missing a few pieces of information:
For every new sequence we created we added a grant statement in the “After script” section of the sequence. The “After script” statements are missing from the resulted alter script. They do appear in the “DDL Scripts” when I generate the entire model.
The resulted file is also missing the names of the foreign keys and the indexes for the foreign keys. These are also included in the “DDL Script”.
(EDIT: Found the solution for this issue. I had to modifty the DDL Script Generation Options for BOTH models to add “Generate Contraint Names” and “Create Indexes to Foreign Keys”. I still have the first issue.)
Is there a way to have these two types of statements in the Alter Script? I’ve tried searching for answers for these questions but I couldn’t find any.
Message was edited by: dbobes_953