SQL Prompt 5.0 is now available
Download SQL Prompt 5
SQL Prompt 5 includes a number of significant new features:
Find Invalid Objects
SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.
Script Object as ALTER from a query window
If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.
View column dependencies
SQL Prompt 5 enables you to view a list of objects that reference a column.
SQL Refactor functionality
SQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Professional Edition, including the following:
- Smart Rename
- Qualify Object Names
- Expand Wildcards
- Split Table
- Encapsulate as New Stored Procedure
- Find Unused Variables and Parameters
- Summarize Script
SQL Prompt 5 is primarily designed to work with SQL Server Management Studio 2005 and SQL Server Management Studio 2008. Reduced functionality is also available in Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010. Please note that SQL Prompt 5 no longer supports Query Analyzer; if you need to work with Query Analyzer then please continue to use SQL Prompt 4.
Microsoft .NET Framework 3.5 is required to use SQL Prompt 5. You can download the framework here.
SQL Prompt 5 is a major version that replaces earlier releases of SQL Prompt. The installer will automatically uninstall earlier versions of SQL Prompt if present.
Upgrading from SQL Prompt 4.x: customized options settings and snippets from SQL Prompt 4 will be automatically migrated to SQL Prompt 5.
Upgrading from SQL Prompt 3.x: none of your customized options settings or snippets from SQL Prompt 3 will be imported into SQL Prompt 5. You may wish to take screenshots before upgrading for your reference.
SQL Refactor: SQL Prompt 5 also replaces SQL Refactor. The installer will automatically uninstall SQL Refactor if it is present on the system. Saved layouts from SQL Refactor will not be automatically migrated: the Lay Out SQL feature is superseded by SQL Promptâ€™s Format SQL feature.
Existing SQL Prompt users without the Support and Upgrades package: You will have a trial license when you install SQL Prompt 5. To continue using SQL Prompt 5 after the trial period, you will need to purchase a new license.
Existing SQL Prompt users with the Support and Upgrades package: If you already have a SQL Prompt 4 valid license number purchased with the Support and Upgrades package then you can use the same license to activate SQL Prompt 5 manually.
Existing SQL Refactor users with the Support and Upgrades package: If you already have a SQL Refactor valid license number purchased with the Support and Upgrades package then you are entitled to a free upgrade to SQL Prompt 5 Professional Edition. Please contact [email protected] for details.
Project Manager, Red Gate