Migrations

Generate a migration script

A migration script changes all database or a part of it. For example, you can use migration scripts to add or remove a column, upgrade the database version, or change column properties.

CLion can automatically generate a migration script that you must check before running.

1. Select two schemas, right-click any of them, and click Compare. Alternatively, select two schemas and press Ctrl+D.

2. In the Diff Between <schema_1> and <schema_2> dialog, specify comparing options.

3. Depending on the migration direction, click Migrate Left or Migrate right.

Modify SQL objects with a migration tool

You can use a migration tool for the following types of SQL objects: procedures, functions, views, materialized views, rules (PostgreSQL), events (MySQL), scripts (Exasol), triggers (except for PostgreSQL).

1. Double-click the database object.

2. Make changes in a source code of the object. CLion highlights all changes in the gutter.

3. Click the Submit icon ().

4. In the Object Migration window, review changes and click OK.