Red Gate forums :: View topic - SQL Prompt 5.0 is now available
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

SQL Prompt 5.0 is now available

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Paul Stephenson



Joined: 23 Jul 2010
Posts: 107
Location: Cambridge, UK

PostPosted: Wed Dec 15, 2010 5:23 pm    Post subject: SQL Prompt 5.0 is now available Reply with quote

SQL Prompt 5 is a major upgrade to SQL Prompt 4.

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


Requirements
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.

Upgrading
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.

Licensing
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 sales@red-gate.com for details.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group