Is there a way to change or customize the “Database Alter Script File” output?
The simplistic output I am getting is this:
This sequence works but is not a best practice in most IT shops because the xyz table is locked during the insert. (could be a long time if the data volume is large)
Best practice creates a new table, inserts data to it, then renames the tables.
If the current ER Studio design does not support customizing the alter DDL in this way, please consider this best practice modification for a future release.