RubyMine 2019.2 Help

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.

RubyMine 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.

Generate a migration script

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. RubyMine highlights all changes in the gutter.

  3. Click the Submit icon (the Submit icon).

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

Migrate a database object
Last modified: 5 September 2019