powershelldba.de
Version history

DbSchemaCompare changelog

Every release, reconstructed from the project's commit history — what changed, and why.

Unreleased

2026-07-25

Fix: false-positive view/proc diffs from cosmetic header syntax

sys.sql_modules.definition preserves the CREATE/ALTER header exactly as originally scripted, so the same view compared identical bodies but different bracket/schema-qualifier styles (e.g. HISTORY_ACC_KDB vs [dbo].[HISTORY_ACC_KDB]) and reported a spurious diff. Normalization now covers only the header's object name; the body (including schema-qualified references) is still compared verbatim.

1.0

2026-07-17

Initial release

Full schema-compare GUI tool for two live SQL Server databases: tables/columns, indexes/constraints, programmable objects (views, procedures, functions), and security, with an HTML report. All objects are matched by name — never column_id/object_id/index_id — after a prior ad-hoc column_id-based comparison produced 12 false "changed" alarms in a real downgrade project. Also detects and neutralizes SQL Server's auto-generated PK/UNIQUE constraint names, which differ between servers even for structurally identical constraints.