Migration Scripts

Vertabelo has a feature that automatically generates migration scripts. These scripts make it possible to change database structure from one version to another. In this way, you can update your database or go back to a previous schema with much less hassle.

Generating a Migration Script

Start by going to your drive. Then pick a model you want to create a migration script for and in the right tab open the Versions tab.

Picking a model

In the Versions tab select a version you want to create a migration script from, and from its drop-down menu select Generate migration from this version.

Drop-down menu for the version

You may also click on the located in the top bar Generate migration script button.

ALT

A view offering selecting versions will show up – just pick deliberately the correct ones. You may also select two versions of two different models. (Just be sure to have Show all models checked.)

Selecting versions

When you're done, click on the GENERATE button. After a while, your script will be generated, and you'll have to just click on the DOWNLOAD button. Alternatively, you may just save the file within your drive by clicking on the Save and Open button.

Download button