Redgate Software Enhances SQL Prompt with New Capabilities

Redgate Software is upgrading SQL Prompt, elevating it from helping to develop and standardize new code to discovering problems in legacy code.

The latest update to SQL Prompt allows users to analyze an entire script of legacy code, no matter how large, and see a list of all the issues contained within it. If users double-click on an issue, they’ll see that line highlighted in the code and can view more details. Code issues can also be grouped by type and exported to a CSV file which can be shared across a team or attached to a ticket in bug-tracking or task management software.

This makes it easy to learn about the health of certain sections of the database code, or assign clean-up tasks, with each developer on a team assigned a set of issue types.

By acting as a worklist for improving overall code quality, it makes it much easier to do code reviews, discover technical debt, and resolve small errors before they become big problems.

It helps teams prevent technical debt from entering the code base, remove it from existing code, and ensure that released code conforms to the team’s defined coding standards.

Existing users of SQL Prompt can start using the new functionality immediately by updating to the latest version using the Check for Updates link in the Help menu.

 New users can explore the feature by downloading a fully-functional trial version of the software from the Redgate website. Once installed, SQL Prompt will appear in the standard menu of SQL Server Management Studio or Visual Studio and can be used just like any other feature of the IDE.

SQL Prompt plugs into SQL Server Management Studio and Visual Studio and enables developers to write, format, refactor, and analyze SQL code.

For more information about this update, visit