Let me reply to your question.
Let’s say I start with a complete physical model of the DB (reverse engineered). At one point, I change the model (this is common during development). So, I want to create a SQL script to migrate/alter the DB for that change.
After RE a new model is created. After you make changes in the model, you will generate alter script via the Sync & Convert Wizard.
Then use a third party software to run the script (for Oracle databse e.g. Toad for Oracle).
Unfortunately, I’m not quite sure about this (I apologize for my English):
At the time of releasing, I want to generate a script to migrate my production databases to the new model.
Do you want to generate the script in TDM? What kind of script? Do you mean standard RE and SQL/DDL script generation for the reversed model?
I can imagine the following scenario: You updated your database (ran the alter script generated by TDM). So, now the database and model in TDM are identical. Then you make some modifications in the database and need to update the existing model in TDM. In this case, you can:
a) use the Model Update feature (Model | Model Update)
b) do the RE again - a new model will be created - and then compare and merge the models. This allows you to merge either to the existing model or to a new model. For the model, you can generate SQL/DDL script. -> Is this what you want?
Flash movie on model merge:
If not, please write me more details. Thanks a lot.