RubyMine 2019.1 Help

Differences viewer for table structures

Compare table structures

Comparison statuses are shown in the column marked with an asterisk (*).

Icon

Description

The column, constraint or index exists only in the left-hand table

The column, constraint or index exists only in the left-hand table.

The items exist in both tables but their definitions are different

The items exist in both tables but their definitions are different. You can study the differences in the lower part of the view.

The items are identical

The items are identical.

The item exists only in the right-hand table

The item exists only in the right-hand table.

Generating ALTER TABLE statements

You can generate a set of ALTER TABLE statements for making data definitions in the left-hand and the right-hand parts identical. Use one of the following buttons in the upper part of the view:

  • Migrate Left: the statements for the left-hand table or tables are generated.

  • Migrate Right: this buttons does the same but for the right-hand table or tables.

The ALTER TABLE statements are generated for the items marked the Arrow right icon, the Not Equal icon and the Arrow Left icon. If you don't want to generate the statements for some of those items, right click the * cell and select Set Do Nothing for all such items.

Last modified: 8 May 2019