How to I add new columns or remove columns for a DB?
faroukya 6 years ago • updated by Michał Kołodziejski 6 years ago • 1
Let' say I reversed engineered from an existing DB which got data records. I want to add more columns to 1 table. I can only see create and drop script. If i do this, I will lose the data records. Any way I can retain them?
Customer support service by UserEcho
You can generate a migration script between model versions.
In order to do that, please go to "Model details" page (either from right-hand side panel on "Documents" page, or using drop-down on top-left of diagram page, or using ctrl+m shortcut from diagram), and then click on "Generate migration script".
Please note that there are some operations that require manual adjustments in generated script.
Hope this helps.