PostgresCompare 1.1.104 Released

[PostgresCompare](https://www.postgrescompare.com) is pleased to announce
the release of version 1.1.104, along with a summary of recent highlights
from 1.1.103.

PostgresCompare connects to two live PostgreSQL databases, detects schema
differences across tables, views, functions, indexes, types, and 30+ other
object types, and generates a ready-to-run SQL deployment script to
synchronise them. It runs on Windows, macOS, and Linux.

## New in 1.1.104

**Pre/post deploy scripts** — Projects can now include custom SQL that runs
before or after the generated deployment script. Useful for pre-flight
checks, disabling triggers, setting session variables, or post-deployment
verification. Both editors use Monaco with full SQL syntax highlighting and
scripts are saved with the project.

**Global search** — A new search bar lets users find projects, environments,
and comparison objects from anywhere in the application. Results are grouped
by type and update as you type.

**Keyboard navigation** — The difference list now supports up/down arrow key
navigation, making it faster to move through a large set of differences
without the mouse.

**Dependency cascade selection** — Selecting a script statement automatically
selects any statements it depends on, preventing incomplete deployments
caused by missing dependencies.

**Redesigned comparison card** — The comparison summary card now includes
progress bars and a breakdown of difference types for a clearer at-a-glance
view of what changed.

## Recent Highlights from 1.1.103

**Destructive change warnings** — Deployment scripts now classify every
statement by risk level before you run them. Destructive statements (e.g.
DROP TABLE, DROP COLUMN) are highlighted in red, warning-level statements
(e.g. DROP FUNCTION, DROP VIEW) in amber, with icons and glyph markers in
the SQL editor. A summary banner shows the total count so nothing is
missed.

**Hover to preview differences** — Hovering over any row in the statement
list shows a floating diff popover with the before and after SQL
side-by-side, without leaving the script screen.

**Deployment script section headers** — Generated scripts now group
statements by object type (Tables, Views, Functions, Indexes, etc.) with
clickable section headers in the statement list. A script header records the
version, source and target database names, and timestamp.

## Availability

PostgresCompare 1.1.104 is available for Windows, macOS, and Linux.
A 30-day free trial is available with no credit card required.
PostgreSQL versions 9.2 through 18 are supported.

- [Download PostgresCompare 1.1.104](https://www.postgrescompare.com/downloads)
- [Full release notes](https://www.postgrescompare.com/release-notes)