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 (D163777, D163792)
- Fixed an issue with the display of privileges in schema comparison documents (D147530)
- 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 (D128970)
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 (D116719)
- Fixed an issue with describing stored procedures on RedShift (D115627, p217827)
- Fixed an error that occurred when creating an HTML report from the command line (D115292)
- Fixed an error that occurred when comparing CHECK constraints (D117932)
- Fixed unexpected behavior that caused an invalid comment to be generated for a column (D113130)
- Fixed an issue with processing tables containing columns of PostGIS data types (D112008, D113077, D114900, D115309, D115322, D115486, D120984)
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 (D74998)
- Substituted the error that occurred when trying to access the pg_shadow schema without proper rights with a warning (D69369)
- Fixed an error that occurred when comparing the data types of procedure parameters (D65629)
- Fixed the retrieval of database objects on older versions of PostgreSQL (D66474)
- Fixed an error that occurred when using the DESCRIBE command (D74998)
- Resolved an issue with table columns comparison (D76561)
1.2.211 22-Nov-22
User-reported and internal bug fixes
- Fixed PostgreSQL connection issues (D77328, D96831)
- 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 (D65023)
- Fixed an issue with the detection of differences in table-valued functions (D65023)
- Improved behavior of the synchronization of procedures and functions using CREATE OR REPLACE (D65023)
- Improved mapping behavior for overloaded procedures and functions (D65023)
- Fixed an error that occurred when connecting via the SSH protocol (D66437)
- Fixed an error that occurred when loading the application cache file (D65159)
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, T320244, D54349)
- 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, D50118, D52748, T32219648, T3250450 T323063, T324583, T325078, T322196, T324583, T323063, T325212, D58578, D52748, D55959)
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
© 2024 Devart. All rights reserved.