Updating remote databaseΒΆ

On the Eclipse tool bar, set the parameters for getting a DB schema basing on which a DDL script for applying changes to the remote database will be generated.

On the action panel, click Get changes. After a short wait, the list of objects with indication of change type will be displayed on the differences panel.

_images/changes_list.png

Select DB as the direction of changes, tick the necessary changes and click Apply.

When script generation is finished, SQL editor will open. Check the generated script, make changes manually if needed.

_images/sql_editor.png

To apply the migration script to the database, specify the method of its execution. Updating via JDBC is used by default. If you want to use another utility or bootup options it is possible to change settings of the current DB. See DB storage for more.

_images/new_connection_pg_dump.png

After selecting the update method and entering the necessary parameters, click Update DDL or use hotkey (Ctrl + Alt + R by default). Migration script will be applied to the specified database. You can see current progress in the pgCodeKeeper console.

_images/console_log.png

For bigger flexibility, there is an opportunity of migration of a selected fragment of code.