Answered

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

8 ár síðan • updated by 8 ár síðan • 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

Vote

Replies 1
Elsta fyrst
- Nýjast fyrst
- Elsta fyrst

Answered

8 ár síðan

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.

Reply
- Er það?
- Óviðeigandi
- Ruslpóstur
- Afrita
|

Customer support service by UserEcho