1. Vertabelo
  2. Preguntas
0
Respuestas

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

faroukya hace 8 años • actualizado por anonymous hace 8 años • 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

Respuestas
anonymous hace 8 años

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.

Servicio de atención al cliente por UserEcho