1. Vertabelo
  2. Questions
0
Answered

Modify Database

Bhaskar G 8 years ago • updated 8 years ago • 2

Once I generate SQL and create my database, is it possible to generate "modification" sql, which might involve saving old data and re-inserting in new tables?

Answered
Rafał Strzaliński (Senior Engineer) 8 years ago

Hi,


Yes you can. We call them "migration scripts".


Here are steps to generate migration script:

1. Sign in

2. Right click on the database model and pick "Model details" option (the last one)

3.On "details" screen click "Generate migration SQL" link (on the right site panel)

4. You'll see the migration tool. Here you can pick a source model and target model or version.

5. Click "Generate"

6. You'll get migration script + warnings.


Hope it help. If you have any questions please do not hesitate to contact us.


Bhaskar G 8 years ago

That's great, Thanks. I have another question: do you have spread-sheet style editing of columns?

Customer support service by UserEcho