Alter Script Questions

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:

  1. 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.

  2. 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.

Thank you,

Message was edited by: dbobes_953


Thanks for your question.

After Script and Before Script sections - You’re right. They are not generated in alter script in current TDM version. Nevertheless, I’m pleased to inform you that it was fixed for the upcoming Beta 3.5.2. It will be fixed in next official release too.
(CR 66 296 - fixed.)

Yes, please modify the settings in DDL Script Generation dialog for BOTH models. Thanks.

If you have any questions, please do not hesitate to write us. Thanks.


Vladka + TDM Team