Compare SQL Server schemas, server configuration and data, also across all your environments at once. Generate the deployment script.
New in version 0.1.9
Compare Production with Development, Test, Acceptance and any other environment in one run. One matrix shows which tables, procedures, permissions or server settings differ where, and a click opens the comparison of that environment, ready to deploy.
Typical compare tools compare one source with one target at a time. Here every environment is side by side, for database schemas and for server configuration.
Pick the comparison, set the source and target, press Compare. Results are grouped by Only in source, Different, Only in target and Identical, with a side-by-side script diff for every object.
Tables, columns, indexes, constraints, views, procedures, functions, triggers, sequences, synonyms, user-defined types, users, roles, permissions and extended properties.
Generates a deployment script from source to target and can run it against the target inside a transaction.
Server properties, sp_configure, trace flags, logins, server roles and permissions, credentials, linked servers, endpoints, server triggers, audits, database options and files, SQL Server Agent, Database Mail, Resource Governor and Extended Events.
Generates a configuration script that applies the source settings to the target.
Row-by-row comparison of matching tables using primary or unique keys. Include or exclude tables and columns with wildcards.
Ideal for reference data and configuration tables that drift between environments.
No database contents, connection details, passwords, scripts or comparison results are ever transmitted to SQLTreeo. Everything stays on your computer.
Select an object to see its property differences and a side-by-side script diff. Filter by text or object type, show or hide a group with one click on its coloured count, and keep the current group pinned while you scroll.
The deployment script is analysed for DROP and data-loss statements and for steps that need manual work, such as passwords, before anything runs. Deploy inside a transaction, or save the script for your change process.
sqlcompare schema ^
--source "Server=dev;Database=Shop;Integrated Security=true" ^
--target "Server=test;Database=Shop;Integrated Security=true" ^
--script deploy.sql --format html --output report.html
# exit code 0: no differences, 1: differences found, 2: errorThe sqlcompare command line runs the same engine without the UI. Compare schema, server or data, write an HTML, JSON or text report, generate the script or deploy it straight from CI.
The desktop app checks for updates at startup and while it runs. What's new shows the release notes of the new version first; installing is one click and the app restarts by itself.
Projects store connections, options and selections. Windows, SQL Server and Microsoft Entra ID authentication are supported. Passwords are saved only when you ask and are encrypted for your Windows account.
Click a screenshot to enlarge it.
Windows 10 or 11. The installer is per user and needs no administrator rights.
SQL Server 2016 and later, Azure SQL Database and Azure SQL Managed Instance. Server-level sections that do not exist on a platform are reported as warnings.
Self-contained win-x64 build for build servers and agents. Supply connections as arguments or through environment variables.
Step-by-step articles, each with a T-SQL check you can run without the tool.
Check whether Development, Test and Acceptance still match Production: find schema drift across all SQL Server environments of a DTAP (OTAP) street in one comparison.
Read the guideCompare sp_configure settings, trace flags, logins, Agent and database options of one reference SQL Server with all your other instances, in one matrix.
Read the guideFind every schema difference between two SQL Server databases: tables, columns, indexes, procedures and permissions. A T-SQL check and the full comparison.
Read the guideFind the rows that differ between two SQL Server databases: missing rows, extra rows and changed values. With EXCEPT in T-SQL, or for all tables at once.
Read the guideCompare sp_configure settings, trace flags, logins, Agent jobs, Database Mail and database options between two SQL Server instances, and script the differences.
Read the guideCheck that two SQL Server instances have the same Agent jobs, operators and logins, for example availability group replicas, and script what is missing.
Read the guideFail a build or raise an alert when a SQL Server database drifts from its reference, with the sqlcompare command line in GitHub Actions or Azure DevOps.
Read the guideFind which tables, rows and objects changed since a backup was made: restore or copy the backup into a scratch database, then compare it with the live one.
Read the guideThank you for your purchase. Your license key is on its way to the e-mail address you used at checkout. Not there within an hour? Check your spam folder, or write to servicedesk@sqltreeo.com.
One license covers schema, server and data. See how that compares with Redgate, dbForge, SQL Delta, ApexSQL and SSDT.
Download SQLTreeo Compare, open it and pick a comparison. The trial starts on first launch and covers every feature.
By installing SQLTreeo Compare you accept the end-user license agreement.