SQL Enlight

Reformat, analyze, summarize, outline and syntax validate T-SQL code

SQL Enlight Features

License Agreement

Download 14-days Trial

Purchase License

SQL Enlight is a simple to use software tool, designed to facilitate, improve and accelerate the database development with T-SQL.

The tool can help the introduction of common T-SQL coding standards and readability conventions over developer teams be done with flawless.

Using its features developers can quickly identify performance and design problems, and make any badly formatted T-SQL legacy code best fit their personal preferences or company standards.

SQL Enlight fully supports T-SQL syntax of SQL Server 2000, SQL Server 2005 and SQL Server 2008.

Development Environment Integration
SQL Enlight integrates with Microsoft SQL Server 2005/2008 Management Studio and Microsoft Visual Studio 2005/2008 as Add-in.
Command Line Interface
SQL Enlight comes with command line tool which support script layout, static analysis of server objects and report generation.
Automated Builds Integration
SQL Enlight includes MSBuild tasks which are meant for supporting the continuous integration software development practice.

Benefits

SQL Enlight is a Transact-SQL management tool that is able to reformat, validate, perform static analysis and summarize Transact-SQL code.

SQL Enlight enables development teams to check T-SQL code compliance with best practices. The tool can help features developers and database administrators to follow their company's coding standards and coding conventions.

SQL Enlight you can considerably improve legacy code readability and maintainability and this way the total team productivity.

Quality

Identify potential issues earlier in development cycle - problems are cheaper to fix the earlier they are identified.
Produce quality code - code analysis is one of the strategies for improving code quality.
Improve T-SQL code readability and maintainability.

Productivity

Develop new code faster with fewer errors.
Facilitate legacy T-SQL code understanding and maintenance using the layout, summarize and outline features.
Provides a big productivity boost by finding issues.
Save time - simply write your code and use SQL Enlight to identify issues with naming, design and performance in your stored procedures, function , triggers and views.
Refactor existing code making it easier to read and cheaper to maintain.
Enhance T-SQL handling in both SQL Server Management Studio and Visual Studio.
Encapsulate T-SQL script as stored procedure or function using just a few clicks.

Standardization

Easily enforce coding guidelines within your team and organization.
Make automatic code reviews.

Configurability & Extensibility

Highly configurable T-SQL layout templates.
Easily implement custom analysis rules which to follow best development team preferences and practices.

Training & Education

Less experienced developers can improve their T-SQL programming skills and get to know the T-SQL best practices with the help of the static code analysis

Features

Analysis

Perform Transact-SQL static analysis
Design and implement custom analysis rules
Validate, Summarize and outline T-SQL script
Integration with automated builds and continuous integration support

Refactoring

Reformat T-SQL code using configurable layout templates
Encapsulate script as stored procedure or function

Click here to read more about SQL Enlight features.

System Requirements

Microsoft SQL Server 2005/2008 Management Studio or Microsoft Visual Studio 2005/2008 *

Windows 2000, Windows XP, Windows 2003 Server or Windows Vista

Microsoft .NET Framework 2.0

256MB RAM

5 MB hard disk space

*Does not support Express editions