Did this migration script actually work?
You ran the deployment. The app starts. But did the schema land exactly the way it did in staging? You're not sure. You won't be sure for a week.
DBA · post-deploy · Friday 18:42
Schema diff · Deployment scripts
Compare any two SQL Server databases. Ship the diff with confidence.
Avesys Database Compare is the schema comparison tool built for DBAs and developers who need to know exactly what changed between two databases — and turn that diff into a deployment script they can trust.
Built for
SQL Server 2016+Windows or LinuxOn-prem · air-gap capableSchema diffReviewable scripts
The problem · sound familiar?
The diff is in your head. It belongs on the screen.
Three questions that come up on every release week — and the kind of answers your team is forced to give without proper tooling.
What changed in production last weekend?
Someone hotfixed something. Maybe two people did. The change log is in Slack, in a ticket, and in someone's head. The actual database is the only source of truth — and you can't read it by hand.
Lead DBA · Monday standup
Is dev's schema still in sync with staging?
Half the bugs your team can't reproduce come down to schema drift between environments — a missing index here, a column type change there. You need to see exactly what diverged, not guess.
Database developer · sprint review
What Database Compare does
Two databases in. A reviewable diff out.
A schema diff and a deployment script — in one workflow. You stay in control of every line of SQL that runs against production. Database Compare reads. You decide.
Schema diff that's actually readable
Side-by-side comparison of every object — tables, views, procedures, functions, indexes, triggers — with the difference highlighted exactly where it lives. Filter to what you care about, ignore what you don't.
+dbo.PromoCode
~dbo.OrderLines
~sp_GetCart
−dbo.LegacyTax
+IX_Order_Date_Status
Deployment scripts you can review before running
Turn any diff into a SQL script. Read it. Edit it. Approve it. Run it when you're ready — never as a black box. The script Database Compare hands you is the one that ships.
01-- Generated by Avesys Database Compare · review before running
02-- Source: SRV-DEV-01 · Target: SRV-PROD-04 · 12 changes selected
03
04BEGIN TRANSACTION;
05
06ALTER TABLEdbo.OrderLines
07 ADDPromoCodeNVARCHAR(20) NULL,
08 DiscountPctDECIMAL(5,2);
09
10CREATE INDEXIX_Order_Date_StatusONdbo.Orders(OrderDate, Status);
11
12-- 9 more statements collapsed · click to expand
Cross-environment
Compare dev to staging, staging to production, on-prem to on-prem.
Cross-version
SQL Server 2016 and later. Windows or Linux. Same workflow either way.
Who it's for
Built for the teams on the hook for the deployment.
If your week ends with "did that change land cleanly?", Database Compare is for you.
DBAs validating migrations
Confirm that schema changes landed cleanly across environments — and prove it on the spot when an auditor or a developer asks.
Database developers
Reconcile local changes with shared dev or staging. See what your branch actually did to the schema — before someone else finds out.
DevOps & release teams
Build deployment confidence into the release pipeline — diffs as evidence, scripts as artifacts, no surprise drift.
Why Avesys Database Compare
Built by people who run SQL Server in production.
We've debugged the bad migrations, chased the schema drift, and written the scripts by hand. The product reflects that.
Database Compare runs inside your network, alongside the databases it's reading. Your connection details, your schema, your data — none of it leaves your environment.
01
Built for on-premise environments
Like every Avesys product, Database Compare runs inside your network. Air-gap capable. No outbound telemetry, no cloud relay.
02
Part of the Avesys platform
If you already run Avesys DPM, Database Compare uses the same operational model and the same engineering team. One vendor, one license portal, one pricing model.
03
Designed by SQL Server practitioners
The diff view, the script editor, the ignore rules — all shaped by DBAs and developers who do this work every week, not by a UI team guessing at the workflow.
SRV-DEV-01
Source · read-only
DBC Engine
Diff · script · review
SRV-PROD-04
Target · read-only
Outbound to SaaS✕ No schema · no data · no scripts leave the network
Air-gap capableRead-only by defaultSame model as DPM
How it works
Three steps, one diff.
From "we have two databases" to "we have a reviewable script" in less time than the weekly status meeting.
Connect
Point Database Compare at your source and target databases. Read-only by default. No agents, no schema modifications on either side.
⏱ 2 minutes
Compare
Schema diff in seconds across every object — tables, views, procedures, indexes, triggers. Filter, ignore, focus on what matters.
⏱ Seconds to minutes
Deploy
Generate a SQL script. Review it line by line. Edit if you need to. Run it on your terms — or hand it to whoever owns the change ticket.
⏱ On your schedule
Pricing
Per-user licensing. Schema diff and CI deploys for every engineer.
One number per seat, every year. CI runner included. Bundle options if you already run Avesys DPM.
Avesys Database Compare · per user
€250 / yr
All features included · all editions · forever
One annual fee per user who runs Compare or pushes deploys. Service accounts and CI runners don't count — automate freely. Read-only reviewers don't need a paid seat.
Side-by-side schema diff
Idempotent deploy script generation
CI runner with PR comment integration
Drift detection alerts
Multi-environment compare
Rollback script generationIncluded
Free updates & upgrades
Priority support
Already on DPM? Bundle pricing available.
Frequently asked
FAQ — the honest answers.
The questions procurement, security, and the DBA team usually arrive with on the first call. Same answers we give them.
Q · 01
Who counts as a "user"?
Any human who actively runs Compare or pushes deploys. Service accounts and CI runners do not count — automate freely. Read-only reviewers in the web UI don't need a paid seat either.
Q · 02
What does it cost?
€250 per user / year, all features included. Volume discounts kick in for 20+ users. Bundle options if you're already on Avesys DPM — talk to us for a number.
Q · 03
Will it work without internet access?
Yes. Database Compare follows the same on-premise design as the rest of the Avesys platform. Air-gap deployments are supported.
Q · 04
What database engines does it support?
Microsoft SQL Server 2016 and later. Windows or Linux hosts. Other engines are not on the near-term roadmap.
Q · 05
Does it run in CI/CD pipelines?
Yes. The CI runner ships with every license at no extra cost and runs unattended in your build pipeline — GitHub Actions, GitLab CI, Azure DevOps, Jenkins — with PR-comment integration on the diff.
Q · 06
Is my schema safe?
Database Compare is on-premise. Nothing leaves your network — no schema, no scripts, no telemetry. Read-only by default on both source and target.
Q · 07
What if I'm already an Avesys customer?
DPM customers get bundle pricing on Database Compare and consolidated billing through the same license portal. One vendor, one renewal, one support channel.
Ready when you are
The next deployment shouldn't be a guess.
20 minutes with a senior DBA, your environment on the screen, your real data — not ours.