SQL enlight

What is SQL enlight?

SQL enlight is static code analysis and refactoring for T-SQL and Microsoft SQL Server.

Formed and refoperator

Quickly apply design style and coding preferences using customizable code formatting rules and refactor SQL code with a set of refactoring commands.

Detect defects

Identify potential problems in real time while writing code or scan SQL Server databases for design and performance pitfalls.

Continuous integration

Perform analysis of your construction process and get detailed reports of design and performance issues.

Make sure that T-SQL code fits your design, style, and best practice guidelines.

Static analysis with SQL enlight

Identify potential problems in real time while writing code or scanning databases in SQL Server for design and performance pitfalls.

Code formatting

Quickly apply design style and coding preferences using customizable code formatting rules.

Refactoring

Refactor SQL code with a refactoring set

Continuous integration

Perform analysis of your construction process and get detailed reports of design and performance issues.

IDE Extension

Integration with SQL Server Management Studio and Visual Studio.

Integration with SSMS and Visual Studio

SQL enlight supports integration with SQL Server Management Studio and Visual Studio as an extension.

Continuous integration support

• Command-line tool, which supports script layout, static analysis of server objects, and reporting.
• MSBuild and NAnt tasks designed to support the practice of continuous integration software development.
• Políticas de check-in do Team Foundation Server.
• Extensão SQL Enlight Code Quality para o Visual Studio Team Services e o Team Foundation Server

Code formatting

Improve the readability of your code by using a set of more than 40 configurable layout rules.

Code quality analysis

Automated code reviews, on-the-fly script analysis, easily analyze and identify potential design and performance pitfalls in SQL Server databases.

Refatorações de código

Extracts large portions of the script into new stored procedures or functions, endor statements and boundary identifiers, and more.

Code Summary

Get an instant overview of yours and browse your T-SQL script using sql enlight script summary.

System requirements

Processor: min. Intel Core 2 Duo 2GHz

Memory: min 2GB

Disk space: 100 MB of hard disk space

Prerequisites: Microsoft .NET Framework 2.0 or later

Supported operating systems (32-bit and 64-bit):

Windows Vista

Windows 7

Windows 8

Windows 8.1

Windows 10

Windows Server 2008

Windows Server 2008 R2

Windows Server 2012

Windows Server 2012 R2

Windows Server 2016

Supported versions of Microsoft SQL Server:

Microsoft SQL Server 2005

Microsoft SQL Server 2008

Microsoft SQL Server 2008R2

Microsoft SQL Server 2012

Microsoft SQL Server 2014

Microsoft SQL Server 2016

Microsoft SQL Server 2017

Azure SQL Database