Online Documentation for DB Comparer for PostgreSQL
Set specific parameters of comparison for each type of database objects.
Here you can specify whether to perform Full database or Schema to schema comparing.
In the latter case select Source and Target schemas by clicking the ellipsis button of the corresponding controls.
Select an object type in the object tree, set a flag to include the object type into the comparison process and define Compare properties in the corresponding group within the Compare Options tab.
The Script generation group allows you to specify whether a specific type of script (CREATE, ALTER, DROP) should be generated for objects of the selected type.
The Select All, Unselect All and Invert Selection buttons are implemented to make options selection easier.
Case sensitive comparing
Enable this option to make the comparing process case sensitive.
Analyze renamed objects
This option enables/disables comparing databases object which might have been renamed.
Do not set current values for sequences
If this option is checked then the sequence in the target database is created with the '0' start value.
Show objects list
If this option is checked the list of all objects is displayed on the next step. If there is no need to check the list of retrieved objects you can uncheck this option to speed up comparison process.
Check function bodies on script execution
If this option is disabled then a script will be executed even in case the function body is syntactically incorrect.
Add comments to generated script
Use this option to toggle comments in modification script.
You can also set filtering criteria for objects to be compared. Use the Filter options tab for that purpose. For details see Setting compare options.