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.
PyCharm can automatically generate a migration script that you must check before running.
Select two schemas, right-click any of them, and click Compare. Alternatively, select two schemas and press Ctrl+D.
In the Diff Between <schema_1> and <schema_2> dialog, specify comparing options.
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).
Double-click the database object.
Make changes in a source code of the object. PyCharm highlights all changes in the gutter.
Click the Submit icon ().
In the Object Migration window, review changes and click OK.