Is it possible to generate DDL from an ERD that represents the differnces between one version and another i.e. the required alter statement. dropping and re-Creating is not possible practicle for Production Databases.
If not can this be puit forward for future enhancement.
Thanks for your inquiry. When you have generated the database, you can run Update Database (select Update Database at Tools > ORM > Generate Database) and check Generate DDL. After that, you will get the alter statement generated in the DDL.
Alternatively, you can select some/all entities on the ERD, right-click on them and select Generate SQL to get the alter statement. Hope these help. Please feel free to contact me if there is any further inquiry.
BTW, please be reminded that we will not generate drop statement nor alter the type of existing columns.