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

faroukya 7 лет назад обновлен anonymous 7 лет назад 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?


Farouk Yew


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.

Сервис поддержки клиентов работает на платформе UserEcho