Compare two SQL Server databases
See what changed between two SQL Server schemas.
Point DiffyPick at two SQL Server databases and it lists every table, column, index and constraint that differs — then generates the T-SQL to bring them in line, on macOS and Windows.
Why it is harder than it should be
Schemas drift between environments, and what the database actually looks like is the only source of truth.
DiffyPick reads both schemas directly and shows the difference as a clean, per-object list — without a Windows-only tool.
The manual way
You can script both schemas from SSMS with Generate Scripts and diff the output, or query the sys catalog views by hand.
It is manual and slow, and the polished GUI option — Redgate SQL Compare — is Windows-only and paid.
DiffyPick compares object by object, writes the T-SQL, and runs natively on macOS and Windows.
With DiffyPick
Connect both databases
Pick the two SQL Server connections, then the database and schema on each side.
Compare
Every differing table, column, index, constraint, view and procedure is listed as a diff, color-coded and searchable.
Review and sync
Preview the generated T-SQL statement by statement, pick what to apply, and run it — or export an HTML report.
What you get
- A native macOS and Windows app — no VM, no Windows-only lock-in.
- A per-object diff with the T-SQL generated for you.
- Preflight checks and one-click backup before anything runs.
- The same workflow across PostgreSQL, MySQL, MariaDB and SQLite too.
Compare your SQL Server schemas now.
Free for SQLite; connect SQL Server on a paid plan. No account needed to start.