Set-up Packages Comparison options
Package comparison is a comparison of data and structure.
- Select Comparison Options from
Tools main menu.
- Go to Packages Comparison tab.
- Use check-boxes to select/unselect comparison options, according to your strategy.
Understanding Packages Comparison options:
- Compare tables/views structure – if you select this option, table's structure will be compared according to the settings defined in the "Structure Comparison" tab. If you omit this option, the structure will not be compared. [Default value – selected].
- Compare primary keys – if you select this option, the primary keys will be compared according to the settings defined in "Primary Keys Comparison" tab. If you omit this option, primary keys will not be compared. [Default value – selected].
- Compare indexes – if you select this option, indexes will be compared according to the settings defined in the "Indexes Comparison" tab. If you omit this option, the indexes will not be compared. [Default value – selected].
- Compare foreign keys – if you select this option, foreign keys will be compared according to the settings defined in the "Foreign Keys Comparison" tab. If you omit this option, foreign keys will not be compared. [Default value – selected].
- Compare tables/views data – if you select this
option, the data will be compared. If you omit this option, data comparison
will not be a part of the package comparison algorithm. [Default value –
selected].