Online Documentation for DB Comparer for PostgreSQL

Version history

 

 

 

Version 5.0.2

• Comparison of renamed objected added to the console version.
• Filter for compared objects improved.
• Batch or PowerShell file type can be now selected on saving the template.
• The issues of scaling the application window resolved.
• SSH passphrase prompt was missed in some cases. Fixed now.
• Support for CONCURRENTLY option added for indices.
• INCLUDE parameter is now generated for indices.

 

Version 5.0.1

• Support for Windows 11 ARM implemented.
• Support for PostgreSQL 15 added.
• IF NOT EXISTS is implemented for sequences.
• Some errors occurred on comparing views. Fixed now.
• Boosted speed for comparing functions when 2 schemes selected.
• Some improvements in dark schema interface.
• Fixes for report printing.
• "Load last password for new projects" option was not saved in some cases. Fixed now.
• Minor improvements and fixes.

 

Version 5.0

• Support for dark visual scheme added.

 

 

• Added support for SSL connections.
• Work with objects filter considerably improved.
• Support for Unicode database names added.
• Excluded objects are saved to the template correctly now.
• Support of Ed25519 keys implemented for SSH connection.
• Functions were not processed on analyzing renamed objects. Fixed now.
• Script for partition tables with different columns is now generated correctly.
• Schemas with all subobjects can be excluded from the comparison.
• Many other fixes and improvements.

 

Version 4.5.1

• Support for PostgreSQL 13 added.
• Partition tables are processed correctly now.
• Columns order is compared by index in the collection instead of column number in system tables.
• The INCLUDE part is now compared for indices.
• Composite types were not compared correctly in some cases. Fixed now.
• The 'Always exclude the following objects' option wasn't saved to the template. Fixed now.
• The 'Analyze renamed objects' option concerns functions and procedures now.
• Other minor fixes.

 

Version 4.5

• Support for PostgreSQL 12.
• Comparison of tablespace descriptions fixed.
• Improvements in comparison of inherited table columns.
• Tunneling info was not saved into templates in some cases. Fixed now.
• Other minor fixes.

 

Version 4.4.5

• Added support for procedures.
• Added support for PARALLEL option in functions.
• DEFAULT was not generated for ADD COLUMN statement. Fixed now.
• Script for reordering fields with GENERATED ALWAYS option is generated correctly now.
• Object definition windows can be hidden from the main menu.
• Setting options to default didn't reset folder for language files. Fixed now.
• Error window size is saved now.
• Other minor fixes and improvements.

 

Version 4.4.4

• Support for PostgreSQL 11 added.
• Circular references between objects was not detected correctly in some cases. Fixed now.
• Font settings are now applied correctly in SQL Editor.
• Some object names were not quoted. Fixed now.
• Other minor issues have been fixed.

 

Version 4.4.3

• The buttons for easy moving between differences in DDL have been added.
• The IDENTITY option for fields is supported now.
• The right margin can be optional in SQL Editor.
• Rules and triggers for views are synchronized correctly now.
• The "Next value" option is disabled by default now.
• Types are displayed correctly in the database tree now.
• The statement for Owner was sometimes synchronized incorrectly. Fixed now.
• Other fixes and improvements.

 

Version 4.4.2

• Support for PostgreSQL 10.
• Support for partitioned tables has been added.
• Some functions from extensions are processed as system now.
• Sequences are now recreated after recreating the tables.
• Foreign servers having different order of options are marked as identical now.
• Nextval value is compared in sequences now.

 

Version 4.1

• The process of analyzing and comparing objects is considerably increased.
• Added the possibility to check the function body when executing a synchronization script.
• Now in the synchronization script the function body is dollar-quoted (e.g., $function body$).
• Added the possibility to save the project at any step of the wizard.
• Added the possibility to bulk turn on/turn off the object properties at the Compare properties step.
• Other improvements and bugfixes.

 

Version 4.0

• The algorithm of object comparison and script generation is significantly improved, now it takes into account all particularities of PostgreSQL server.
• Added the possibility to search and analyze the renamed objects. The application now analyzes databases and creates a list of objects, which might have been renamed.
• Added the Project Management Wizard.
• The list of comparison properties for objects is expanded, that makes the database analysis more complete.
• Added the support of new Windows 7 features: a progress bar in the taskbar and Jump List with a list of projects.

• Added the possibility to select client encoding when connecting to.

• Some other improvements and bugfixes.

 

Version 3.3

• Unicode support for metadata is implemented..

• Primary keys with system names used to be synchronized improperly. Fixed now.

• "Load last password for new projects" option worked sometimes wrong Fixed now.
• Other small improvements and fixes.

 

Version 3.2

• PostgreSQL 8.3 support is implemented.
• Database comparison speed is considerably increased.
• Other minor improvements and bug-fixes.

 

Version 3.1

The rules were skipped when creating views. Fixed now

• When comparing databases on Chinese Windows localization, the "Error: RichEdit line insertion error" message used to appear. Fixed now
• Other minor improvements and bug-fixes

 

Version 3.0

• Comparing and synchronization of databases or schemas on different servers as well as on a single server
• Comparing all database objects or selected ones only. Comparing by all or selected properties of objects only
• Visual representation of the differences between databases with details and modification scripts for the different objects
• Ability to synchronize databases manually step by step or automatically
• Ability to generate reports with database differences. Ability to add custom reports
• Ability to automate the database comparison and synchronization using the Console Application
• Working with several compare projects simultaneously
• Saving and loading projects with all their parameters
• A wide variety of options for comparison and synchronization
• Built-in SQL Script editor with syntax highlight
• New state-of-the-art graphical user interface
• Latest PostgreSQL version support

Scroll to top

Version 2.2

• Added the ability to filter analyzed objects using regular expressions. This allows one to analyze only required objects, and increases the speed of comparing and analyzing processes
• Added the opportunity to connect via SSH/HTTP tunnel
• Visual representation of definition differences implemented
• The 'Hide identical objects' option added. This option allows one to hide identical objects in the DB Tree
• Large databases are now compared faster
• Ability to refresh different types of objects separately implemented. This may be helpful when you synchronize databases in the step-by-step style
• Toolbar with list of working windows is added to the main program window
• The 'Synchronize databases after comparing in console mode' option added. This project option allows you to run the console application in synchronization mode by default (without defining the /E option)
• The 'Fill Table View on load' option added. This option can be used to increase the speed of comparing process and decrease memory usage
• The ability to set the default directories for grid exports and reports storage added
• No more delays occur while navigating DB Tree with large databases
• Fixed the saving passwords error
• Procedures were not compared correctly in some cases. Fixed now
• Functions were not compared correctly in some cases. Fixed now
• Sometimes an error occurred while refreshing databases. Fixed now
• The ability to compare two schemas (including the schemas of the same database) added
• Functions containing differences in their return types were not synchronized correctly. Fixed now

and other minor improvements and small bug-fixes.

Scroll to top

Version 2.1

• Now the direction of synchronization can be saved in the project file (also can be used by the Console application)
• Export to Excel, Text, XML and HTML formats is now available from the Grid view
• New, more detailed console application log is implemented
• Now it is possible to select fields from the list when creating user reports
• Hints for the objects in tree are now displayed correctly
• When creating a new report, its pages used to be missing. Fixed now
• When changing Compare Options for a project, the Access Violation error emerged. Fixed now

Scroll to top

Version 2.0

• Completely re-designed top-of-the-art user interface
• Ample opportunities for customizing your working environment
• New way of browsing differences between compared databases
• Easy viewing of all different properties of database objects
• Ability to print a pre-defined differences report or create a new one
• New advanced comparison options
• Improved sync script generation
• Multilanguage support
• A lot of other improvements and bug fixes

and more...

Scroll to top

Version 1.3

• Fixed a bug concerned with incomplete maximization of the main program window
• PostgreSQL 8 support
• Some minor visual improvements and bug-fixes.

Scroll to top

Version 1.2

• Implemented the console version of the database comparison utility: now you can schedule your database structure synchronization routine using the database utility
• Full support of PostgreSQL 7.4
• Now you can compare the Next Value parameters in sequences
• Now DB Comparer does not try to create a primary key if the table already has one. The utility drops the existing primary key and creates another one
• Using this version you can compare and synchronize primary keys regardless of key names.
• Now you can view project properties without actually loading the project file - just open it while holding down the Shift key
• We have implemented synchronous scrolling in the Master Definition and Target Definition windows
• Now project files are associated with particular database comparison utilities
• Some small improvements and bug fixes

Scroll to top

Version 1.1

• Significantly increased the comparison speed for the databases with large amount of objects
• Now the fields order is considered on comparing tables. You can enable or disable this feature by using the 'Field order' option available within the Compare Options tab of the 'Project Options' dialog
• Now you can view the project options just before the project loading. Check the 'Show Project Options before Loading' option available within the Project Options section of the Environment Options dialog to enable this feature
• Added two new options to the Project Options section of the Environment Options dialog - 'Enable Forward Navigation' and 'Enable Backward Navigation'. Using these options you can customize the navigation behavior. If the forward navigation is enabled, you can navigate between the generated SQL scripts by selecting the proper objects from object trees, and vice versa (if the backward navigation is enabled)
• Now you can copy the Object definition to the clipboard
• Some small improvements and bug-fixes

Scroll to top

Version 1.0

Basic features:

• Comparing databases on one server as well as on different servers
• Synchronous navigation between database objects with displaying the corresponding scripts for modifying databases
• Possibility of execution modification statements one by one or all together
• Possibility of editing modification statements and changing their order
• Built-in SQL Script Editor with syntax highlight
• An ability to work with several compare projects at once, as well as save and load projects with all their parameters
• Customizable and easy-to-use MDI Interface
• A wide variety of options for customization
• Keyboard templates for faster editing SQL scripts

and more...

Scroll to top

 

---