2025.1.230 21-Aug-25
User-reported bug fixes
- Fixed the comparison and synchronization of arrays (#206187)
2025.1.186 21-Jul-25
User-reported bug fixes
- Fixed an issue with long file names
- Removed opening the connection on the main thread when opening the parameter input form
2025.1.134 23-Jun-25
User-reported bug fixes
- Added support for parsing geometric arrays with schema specification
2025.1.124 16-Jun-25
Connectivity
- Added support for PostgreSQL 18
Improvements
- Updated color palettes for the Light and Dark skins
- Refined font rendering and the coloring of syntax errors
- Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list
User-reported bug fixes
- Several user reported minor bugs are fixed
1.5.126 03-Mar-25
User-reported and internal bug fixes
- Fixed an error that occurred when using 'plpgsql' in lowercase within an anonymous code block
- Resolved an issue with editing data in tables containing a SERIAL column in Data Editor
1.5.47 03-Dec-24
Connectivity
- Added support for PostgreSQL 17
- Added support for AlloyDB
- Added support for Supabase
- Added support for Google Cloud
- Added support for Azure Cosmos DB for PostgreSQL
- Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to PostgreSQL servers on Amazon Web Services
Text Editor
- Added parameter info and quick info for functions and procedures
- Added suggestions for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses
- Added suggestions for columns declared in scripts for foreign keys within CREATE TABLE and ALTER TABLE clauses
- Added suggestions for existing triggers, ENABLE REPLICA, ENABLE ALWAYS, and potential owners in ALTER EVENT TRIGGER clauses
- Added suggestions for existing triggers in DROP EVENT TRIGGER clauses
- Added suggestions for CREATE OR REPLACE, FOR EACH ROW, FOR EACH STATEMENT, DEFERRABLE INITIALLY DEFERRED, and DEFERRABLE INITIALLY IMMEDIATE in CREATE TRIGGER clauses
- Added suggestions for triggers along with the tables and views they are based on in ALTER TRIGGER clauses
- Redesigned Query History, whose toolbar now includes an updated range selection and a button that clears the history
- Added the ability to duplicate, remove, and join current lines in SQL documents using shortcuts
Improvements
- Added support for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses
- Added support for the comparison and synchronization of DML and event (DDL) triggers
- Improved the comparison and synchronization of UNIQUE constraints
- Added full support for the comparison and synchronization of CHECK constraints
- Implemented access to the automated generation of comparison reports directly from the Comparison Report wizard
- Added new customization options for the automated generation of comparison reports
- Implemented an option that sets the value of a cell to a unique identifier from the Data Editor context menu
User-reported and internal bug fixes
- Fixed metadata retrieval that could fail on specific server versions (#163777, #163792)
- Fixed an issue with the display of privileges in schema comparison documents (#147530)
- Improved support for special values in datetime datatypes
1.4.839 17-Jan-24
User-reported and internal bug fixes
- Fixed an error that occurs when switching between Card View and Grid View in the Data Editor
1.4.832 10-Jan-24
Improvement
- New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane
User-reported and internal bug fixes
- Several user reported minor bugs are fixed
1.4.789 27-Nov-23
User-reported and internal bug fixes
- Added support for server sequences starting from PostgreSQL server version 9.1 (#128970)
1.4.701 18-Aug-23
User-reported and internal bug fixes
- Fixed an error that occurred when parsing the bodies of scripts containing CREATE FUNCTION/PROCEDURE statements
1.4.696 16-Aug-23
Connectivity
- Added support for PostgreSQL 16
User-reported and internal bug fixes
- Fixed an issue with the quoting of case-sensitive names that occurred during the generation of a synchronization script
1.4.618 24-May-23
Connectivity
- Added connectivity Support for EDB BigAnimal
- Added support for TLS 1.3
- Added the ability to connect to the database server via SSH using SHA-256/512 algorithms
- Added support for Aiven Cloud
Improvements
- Added new options for effective tab management
User-reported and internal bug fixes
- Fixed the comparison and synchronization of functions that return a table (#116719)
- Fixed an issue with describing stored procedures on RedShift (#115627, p217827)
- Fixed an error that occurred when comparing CHECK constraints (#117932)
- Fixed unexpected behavior that caused an invalid comment to be generated for a column (#113130)
- Fixed an issue with processing tables containing columns of PostGIS data types (#112008, #113077, #114900, #115309, #115322, #115486, #120984)
1.3.472 30-Jan-23
General
- Added support for SERIAL datatypes
- Added support DEFAULT for function parameters
- Added support for Sequences
- Added option Show Ignored Differences
- Added possibility to select database in comparison wizard
Text Editor enhancements
- Added support for the SELECT INTO statement
- Added suggestions for the names of non-aggregated columns in the GROUP BY clause
- Added support for Ctrl+C/X/V hotkeys for coping/cutting entire line in SQL documents
- Introduced a triple-click to select the entire line in SQL documents
- Added support for RAISE [ NOTICE | WARNING | INFO ] to trace userscript messages in the Error List & Output windows
Other
- Added connectivity support for PostgreSQL 15
- Extended support for high-DPI devices
- Improved the behavior of the Retrieve Data feature
- Added connectivity support for AWS Babelfish
- Added connectivity support for YugabyteDB
- Added connectivity support for Neon.tech
- Added connectivity support for Digitalocean Managed Databases
- Added connectivity support for CitusData
- Added connectivity support for ApsaraDB
- Added connectivity support for PolarDB
- Added connectivity support for AnalyticDB
- Added connectivity support for Bit.io
User-reported and internal bug fixes
- Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys (#74998)
- Substituted the error that occurred when trying to access the pg_shadow schema without proper rights with a warning (#69369)
- Fixed an error that occurred when comparing the data types of procedure parameters (#65629)
- Fixed the retrieval of database objects on older versions of PostgreSQL (#66474)
- Fixed an error that occurred when using the DESCRIBE command (#74998)
- Resolved an issue with table columns comparison (#76561)
1.2.211 22-Nov-22
User-reported and internal bug fixes
- Fixed PostgreSQL connection issues (#77328, #96831)
- Fixed several minor errors
1.2.182 07-Oct-21
User-reported bug fixes
- Fixed an issue with the loss of procedure and parameter name quoting (#65023)
- Fixed an issue with the detection of differences in table-valued functions (#65023)
- Improved behavior of the synchronization of procedures and functions using CREATE OR REPLACE (#65023)
- Improved mapping behavior for overloaded procedures and functions (#65023)
- Fixed an error that occurred when connecting via the SSH protocol (#66437)
- Fixed an error that occurred when loading the application cache file (#65159)
1.2.124 29-Jul-21
New features and improvements
- Improved Text Compare Control
- Comparison Reports
- Additional Scripts tab added to the Schema Comparison wizard
- Support for materialized views comparison and synchronization in Amazon Redshift
- Connectivity Support to Heroku Cloud
- Object Filter
User-reported bug fixes
- Fixed an issue occurred when reading user metadata for servers below v9.5 (T317370, T325155, T317578, T320254, #54349)
- Fixed a bug in the FOREIGN KEY script for Redshift (p178147)
- Fixed an error occurred when working with the IDENTITY column (p178147)
- Fixed an error occurred when working with function parameters during the comparison (T322066, T322479)
- Resolved an issue with getting the table columns metadata (T319194, T319498, T319794, T320733, T320734, T324702, T325050, T325078, T322196, T324583, T323063, T325212, #50118, #52748, T32219648, T3250450 T323063, T324583, T325078, T322196, T324583, T323063, T325212, #58578, #52748, #55959)
1.1.1 23-Nov-20
New features and improvements
- Connectivity support for PostgreSQL v.13
1.0.52 03-Sep-20
First release of dbForge Schema Compare for PostrgeSQL
- Support for Amazon Redshift schema comparison and sync
- Basic support for comparing PostgreSQL schemas with Amazon Redshift schemas
© 2025 Devart. All rights reserved.