0
Answered

How to I add new columns or remove columns for a DB?

faroukya 3 years ago updated by Michał Kołodziejski 3 years ago 1

Hi,

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?


Regards,

Farouk Yew

Answered

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.