Softpedia >Windows >Internet >Servers >Database Utils >EMS DB Comparer for PostgreSQL >  Changelog

EMS DB Comparer for PostgreSQL Changelog

What's new in EMS DB Comparer for PostgreSQL 5.0.2 Build 57103

Sep 7, 2023
  • 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.

New in EMS DB Comparer for PostgreSQL 5.0.1 Build 56234 (Dec 16, 2022)

  • 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.

New in EMS DB Comparer for PostgreSQL 5.0.0 Build 55281 (Jan 17, 2022)

  • 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.

New in EMS DB Comparer for PostgreSQL 4.5.1 Build 54374 (Nov 17, 2020)

  • 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.

New in EMS DB Comparer for PostgreSQL 4.5.0 Build 53382 (Dec 3, 2019)

  • 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.

New in EMS DB Comparer for PostgreSQL 4.4.5 Build 52485 (Apr 3, 2019)

  • 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.

New in EMS DB Comparer for PostgreSQL 4.4.3 Build 51304 (Jun 20, 2018)

  • 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.

New in EMS DB Comparer for PostgreSQL 4.4.2 Build 50641 (Jan 10, 2018)

  • 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.

New in EMS DB Comparer for PostgreSQL 4.4.1 Build 50496 (Nov 21, 2017)

  • Fixed synchronization of functions with custom types as parameters.
  • The Access violation error occasionally occurred on comparing sequences. Fixed now.
  • The functions with table parameters are synchronized correctly now.
  • The functions with differences in parameter names only are processed correctly now.
  • Other minor fixes and improvements.

New in EMS DB Comparer for PostgreSQL 4.4.0 Build 49659 (Jun 5, 2017)

  • Support for PostgreSQL 9.6 has been added.
  • The indices of materialized views are compared now.
  • Subobjects were not excluded from comparison on unselecting the object. Fixed now.
  • The error occurred on inserting data from temporary table after fields reordering. Fixed now.
  • Privileges for functions are compared correctly now.
  • Field defaults are compared without errors now.
  • OWNED BY operator was not generated on adding SERIAL fields. Fixed now. Other bug-fixes and minor improvements.
  • Many other bugfixes and improvements.

New in EMS DB Comparer for PostgreSQL 4.3.0 Build 46958 (Apr 1, 2016)

  • PostgreSQL 9.5 support added, improved script generation for tables, views, sequences, and other fixes

New in EMS DB Comparer for PostgreSQL 4.2.0 Build 46020 (Jul 23, 2015)

  • Dependencies processing mechanism enhanced.
  • New objects support: Range Types, Event Triggers and Collations.
  • The support of the new Types properties added.
  • The support of new data types was added.
  • The inherited tables were compared incorrectly. Fixed now.
  • The comments for Domains are now compared.
  • The sequences are not reset during synchronization.
  • The Composite Types which cannot be altered are now replaced during synchronization.
  • The support of defaults for function parameters added.
  • Lots of other improvements and bug-fixes.

New in EMS DB Comparer for PostgreSQL 4.1.0.1 (Nov 7, 2012)

  • 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.

New in EMS DB Comparer for PostgreSQL 3.3.1.6 (Nov 30, 2011)

  • 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.

New in EMS DB Comparer for PostgreSQL 3.2.0.2 (Nov 11, 2008)

  • PostgreSQL 8.3 support is implemented.
  • Indexes with automatically generated names used to be compared improperly. Fixed now. (SQL Server)
  • Scripts to add the AUTO_INCREMENT field into a table which already contained a primary key were generated improperly. Fixed now. (MySQL)
  • The possibility to compare invalid and broken objects is implemented. (Oracle, MySQL)
  • Database comparison speed is considerably increased.
  • Other minor fixes and improvements.

New in EMS DB Comparer for PostgreSQL 3.0.0.1 (Oct 23, 2007)

  • Major improvements in comparing engine
  • Utility source code significantly optimized, work speed increased
  • Redesign of User interface
  • Schema vs schema comparison is available
  • Advanced filtering capabilities when selecting objects to compare/synchronize
  • New improved SQL Editor and much more