SQL Enlight vs TSQLLint

SQL Enlight is a static analysis and refactoring tool for SQL Server and T-SQL. It examines code and databases for defects and supports server health monitoring, diagnosis, and performance tuning. Developers can validate syntax, run automated reviews, and apply automatic fixes to some code and database issues. Formatting, script summaries, and outlines help make large scripts easier to work with; sections can also be extracted into stored procedures or functions. Developers and database administrators can create custom analysis rules with XPath and XSLT. The tool integrates with SQL Server Management Studio and Visual Studio, and supports build workflows through Team Foundation Server check-in policies, MSBuild tasks, a command-line interface, and an Automation API. Its Azure DevOps extension supports build analysis, quality gates, reports, and pull-request checks and comments; a SonarQube plugin adds T-SQL issues, measures, rules, and quality-gate integration. SQL Enlight supports SQL Server 2005 through 2022, including Azure SQL Database. The paid product has a 14-day evaluation period. Licenses include email support, updates, and documentation access.

TSQLLint checks T-SQL scripts for anti-patterns and reports the findings. Its command-line tool can correct issues it identifies as auto-fixable with the --fix or -x option. Rules can be set to off, warning, or error; an error-level violation produces a non-zero exit code. Users can save settings in a .tsqllintrc file, or use the tool’s in-memory defaults when no file is present. The listed SQL Server compatibility levels are 80, 90, 100, 110, 120, 130, 140, and 150. Custom .NET plugins can extend it if they implement TSQLLint’s IPlugin interface and target net6.0. Before linting, it substitutes SQL file placeholders with values from environment variables. Official installation methods include dotnet-tool, Homebrew, and NPM. Its VS Code extension marks potential problems in opened .sql files for inspection on hover, and SQL Server Management Studio can invoke it through External Tools. TSQLLint is free under the MIT License and runs on Linux, macOS, and Windows, with an editor extension also listed.