Updating remote database

On the project editor tool bar, open the set the Get Changes refresh drop-down menu, or in the drop-down list on the editor tool bar. Next, select the database source based on which a DDL script for applying changes to the remote database will be generated.

Click refresh. After a short wait, the list of objects with the indication of change type will be displayed on the differences panel.

_images/changes_list.png

Open the Apply save_edit drop-down menu and select database DB. You can get the same menu of selecting the direction of changes if you click the Project label. Tick the necessary changes and click save_edit.

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.