Database diff

  • Start the database diff wizard: pgCodeKeeper - Diff Wizard or right-click for the pgCodeKeeper project menu and select pgCodeKeeper - Diff….
  • Select the source of the original database schema which you want to update and the target database schema, basing on which you are going to update the original one.
  • Select additional parameters: sources encodings and database time zone.
  • If you use MS SQL dump, select the corresponding option.
  • Click Next.
_images/diff_wizard_1.png

In the comparison table, select the differences that should be applied. Note: tool bar works similarly to the pgCodeKeeper project editor tool bar.

_images/diff_wizard_2.png

After clicking Finish, SQL editor with migration script, generated for the selected changes, will open.