Enhancements in Ubitsoft SQL Enlight v1.3

  • Integration with Visual Studio 2008 and SQL Server Management Studio 2008 CTP

New features:

  • Transact-SQL Script Analysis

    Scan Transact-SQL code for design and performance problems, deprecated syntax and get best practices recommendations using 22 code analysis rules.

  • SQL Enlight Error List

    Use SQL Enlight Error List to view and locate all syntax errors and analysis rule violations.

New features in Ubitsoft SQL Enlight v1.2

  • Transact-SQL Script Summary

    Using the Script Summary you can view a short hierarchically summary of all batches and statements in the current T-SQL script.

  • Separate T-SQL script validation command

    Using the Validate SQL command you can identify syntax errors in a T-SQL script without SQL Server connection.

  • Join clause alignment layout rule

    This new layout rule modifies the placement of the join clause in the SELECT statements.

  • Tabify white space layout rule
    This layout rule can specify if to replace the tab sized white space with tabs or spaces.

Enhancements in Ubitsoft SQL Enlight v1.1

  • Full support of SQL Server 2005 Transact-SQL grammar.
  • Improved integration with Visual Studio 2005 and SQL Server Management Studio 2005

New features

  • Transact-SQL statements outlining

    Transact-SQL statements outlining feature can supply better readability and help the developers and database administrators to identify and analyze long SQL scripts.

  • 3 new layout rules

    Three new layout rules are added to this version that will improve readability and supply more control over the layout of the columns and assignment expressions of DML statements.

  • Error highlighting in the code editor

    When a Transact-SQL syntax error is found in the SQL script, it is highlighted in the code editor and a tooltip describing the error is supplied.

Product features already in version v1.0:

  • reformat T-SQL code with set of customizable rules
  • validate T-SQL syntax
  • change keywords and identifiers case
  • change identifiers delimiter
  • change string delimiter
  • configure and store set of layout rules in layout template
  • quick switching between layout templates

The first public release of SQL Enlight.