SQLTreeo
Release notes

SQLTreeo Compare

Every release of SQLTreeo Compare, newest first. Latest version: 0.1.0.

First previewv0.1.0previewlatest

· Download

  • Schema, server configuration and data comparison in one Windows application
  • Deployment and configuration scripts, run inside a transaction with data-loss warnings
  • sqlcompare command line for CI pipelines with exit codes
  • 30-day trial with every feature, automatic updates

Preview build. The installer is not code-signed yet, so Windows SmartScreen shows a warning during installation. Choose More info → Run anyway.

Three comparisons

  • Schema compare: tables, columns, indexes, constraints, views, procedures, functions, triggers, sequences, synonyms, user-defined types, users, roles, permissions and extended properties, extracted from the catalog views. Ignore options for column order, whitespace and more.
  • Server compare for DBAs: 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 (properties, jobs, alerts, operators, proxies), Database Mail, Resource Governor and Extended Events sessions.
  • Data compare: row-by-row comparison of matching tables on primary or unique keys, with table and column filters.

Results and deployment

  • Results grouped by Only in source, Different, Only in target and Identical. Groups collapse, the current group header stays pinned while scrolling, and rows are tinted by group.
  • Side-by-side script diff for every object with change navigation.
  • Source and target tiles with a swap button. Swapping re-runs the comparison from the models already in memory, so the results follow the new direction instantly.
  • Deploy… generates the deployment script for the selected objects in dependency order, analyses it for DROP and data-loss statements, shows the change summary, and runs it against the target inside a transaction or saves it as .sql.
  • Script… for server comparisons writes the configuration script that applies the source settings to the target, with warnings for manual steps such as passwords.
  • Reports as HTML, JSON or text.
  • Large results stay responsive: first layout of 3,500 objects went from 71 seconds to 1 second and filtering from 25 seconds to 55 milliseconds during development.

Command line

sqlcompare schema, sqlcompare server and sqlcompare data run the same engine from build pipelines. Exit code 0 means no differences (or a successful deployment), 1 differences found, 2 an error. schema --deploy runs the script against the target; server --script writes the configuration script. Connection strings can come from SQLCOMPARE_SOURCE and SQLCOMPARE_TARGET. See the command line reference.

Projects, connections and updates

  • Projects (.sqlcmp) store connections, options and selections. Windows, SQL Server and Microsoft Entra ID authentication. Passwords are stored only on request, encrypted for the Windows user.
  • The application checks for updates at start-up and periodically while running, and installs them with one click. The portable zip does not update itself.

Licensing

  • The first start creates a 30-day trial with every feature. After the trial, comparing stays free; deploying, scripting and exporting reports need a license key.
  • Keys are verified online and keep working for 30 days without a connection. See Trial and licensing.
  • Settings → About shows the version, the license agreement and the third-party notices.

Requirements

Windows 10 or 11, 64-bit. No .NET installation needed. Targets: SQL Server 2016 and later, Azure SQL Database and Azure SQL Managed Instance.