SQLTreeo Compare · Troubleshooting

Diagnostics and logging

Environment variables that turn on timing logs, stack traces and other diagnostics.

When you report a problem, a debug log helps us reproduce it. Set one of these environment variables before starting SQLTreeo Compare.

Variable Effect
SQLCOMPARE_DEBUG=1 Desktop: per-phase timings (extraction, comparison, results build, first layout, filtering, bulk checks) in %TEMP%\sqlcompare-debug.log. Command line: stack traces.
SQLCOMPARE_AUTOTEST=1 Desktop: opens the project given on the command line, compares, exercises the results page and exits. Combine with SQLCOMPARE_DEBUG=1 to measure performance.
SQLCOMPARE_FAKE_UPDATE=1 Desktop: simulates an available update to try the update banner.
SQLCOMPARE_LICENSE_SERVICE Overrides the license service URL (for environments with an outbound proxy).

Platform warnings

Server-level sections that do not exist on a platform, for example SQL Server Agent on Azure SQL Database, are reported as warnings, not as errors. The comparison continues with the remaining sections.

Reporting a problem

Send the log file and the steps you took through the support portal. Never include passwords or production data in a report.