SQL Prompt Pro - Summary

by Red Gate Software - Product Type: Application

Summary

SQL Prompt Pro by Red Gate Software

URLs: red-gate-sql-prompt-pro, red gate sql prompt pro, redgatesqlpromptpro, red-gate, red gate, redgate

Intelligent code completion and layout for MS SQL Server. SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code choices. Automatic script layout provides easy code readability – particularly useful when working with unfamiliar scripts. SQL Prompt is highly productive straight out of the box. It is also customizable so you can make it perform exactly the way you want it to. Using SQL Prompt will improve your productivity and dramatically reduce your time at the keyboard.

SQL Prompt

Write SQL fast and accurately with code completion

Understand code more easily with script layout

Continue to use your current editor – SQL Prompt works within SSMS, Query Analyzer, and Visual Studio

Keyword formatting, join completion, code snippets, and many more powerful features

SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press CTRL+SPACEBAR or when you type "." after a table/view/alias name.

SQL Prompt Pro - Intelligent code completion for SQL Server plus layout for easy code readability.

SQL Prompt Standard - Intelligent code completion for SQL Server.

SQL Prompt works with Visual Studio 2005 and 2008, Query Analyzer, SQL Server Management Studio 2005 and 2008, and SSMS Express Edition.

Feature list

Table/View/Column/Sproc name completion

Layout makes scripts easy to read

JOIN/JOIN ON syntax completion

Expand wildcard to column names list

Object creation-SQL viewing pane

Mouse-over tool tips that give object definitions including a useful summary

Parameter hinting for user-defined functions

Cross-database queries

Distributed queries with linked SQL Server instances

Scripted objects included in candidate list

Cursors, cursor variables, and related statements

Auto-uppercasing of keywords and pop-up after keywords

Column selector screen, plus qualify object/column names option

FeatureStandardProSupported for Visual Studio

Code completion•••

Instant access to schema information•••

SQL snippets•••

Statement expansion•••

Find invalid objects••

Search••

Column dependencies•••

Auto-generation of aliases•••

Script as ALTER from query window••

Wildcard expansion - single instance•••

Wildcard expansion - entire script ••

Format SQL •

Decrypt encrypted objects •

Summarize scripts •

Find unused variables and parameters •

Qualify object names •

Smart rename •

Split table •

Encapsulate as stored procedure •

Uppercase keywords •

What's New in SQL Prompt Pro V5.0

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 4 Release notes

Enhanced user interface

The user interface for intellisense suggestions and object definitions has been redesigned to be less intrusive and to make SQL Prompt's features more easily discoverable.

The Options dialog box has also been completely reinvented, with better navigation and a rationalised set of options.

Improved SQL Grammar support

Enhanced T-SQL grammar support for SQL 2000, SQL 2005 and SQL 2008 SQL server editions. Suggestions are more accurate and reliable, and cover a more extensive scope of T-SQL.

Performance improvements

SQL Prompt 4 caches database objects dramatically faster than SQL Prompt 3, and does so much more quickly across high latency networks.

Snippet enhancements

Snippets are now stored as separate files, and so can be easily shared among other SQL Prompt users.

There is a new, separate interface for creating and managing your snippets, including an option to go to the folder where snippets are stored.

Column picker

The column picker has been radically improved, so that it is simpler to find and use, for example it is now clearly labelled, and shows the number of columns currently selected.

Options

Many SQL Prompt 3 options have been removed and replaced with sensible defaults, to simplify the configuration and make more intuitive behavior. The Options dialog box itself has been drastically re-engineered so that it is much quicker to find the option you want, understand its purpose, and preview its effect.

Right-click context menus

Right-click context menus have been implemented inside your query editor for creating SQL Prompt snippets and applying your preferred formatting to code.

Temporary storage only of database objects on disk

Database objects are only cached during your current session. When closing down your query editor, the SQL Prompt object cache is emptied, to save disk space. Offline mode working is therefore no longer supported.

Format styles (Pro feature)

Styles allow you to save and share your format options with other SQL Prompt users.

Decrypts encrypted objects: (Pro feature)

SQL Prompt 4 can now decrypt encrypted objects from SQL 2000, SQL 2005 and SQL 2008 to allow you to view their creation script.

Importing snippets and aliases

As a major new installation, existing user-created snippets and aliases or your old configuration options will not automatically be imported into v4. Red Gate offers two free tools that help migrate snippets and aliases from v3.9, Snippet migrator and Alias importer.

Installing SQL Prompt 4 will disable SQL Prompt 3 and start a new trial period. If you wish to re-enable SQL Prompt 3 you will need to uninstall SQL Prompt 4. If you have user-defined aliases or snippets in SQL Prompt 3 which you wish to retain, we have a migration tool available.

Intelligent code completion and layout for MS SQL Server.

Pricing: SQL Prompt Pro 5.2 1 User License, SQL Prompt Pro 5.2 5 User License, SQL Prompt Pro 5.2 10 User License, SQL Prompt Pro 5.2 with 12 Months of Support and Upgrades 1 User License, SQL Prompt Pro 5.2 with 12 Months of Support and Upgrades 5 User License, SQL Prompt Pro 5.2 with 12 Months of Support and Upgrades 10 User License, SQL Prompt Pro 5.2 with 24 Months of Support and Upgrades 1 User License, SQL Prompt Pro 5.2 with 24 Months of Support and Upgrades 5 User License, SQL Prompt Pro 5.2 with 24 Months of Support and Upgrades 10 User License, SQL Prompt Pro 5.2 with 36 Months of Support and Upgrades 1 User License, SQL Prompt Pro 5.2 with 36 Months of Support and Upgrades 5 User License, SQL Prompt Pro 5.2 with 36 Months of Support and Upgrades 10 User License, SQL Prompt Pro 5.2 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License, SQL Prompt Pro 5.2 Renewal License - 36 Months of Support and Upgrades 10 User Renewal License

Evals & Downloads: Read the SQL Prompt help file, Read the SQL Prompt Data sheet, Read the Red Gate End User License Agreement, Download the SQL Toolbelt evaluation on to your computer - Expires after 14 days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000, .NET Framework 3.5, .NET Framework 3.0

Keywords: SQL Prompt Pro SQLPrompt

Red Gate Software Red-Gate RedGate

SQL query language

Database DB Management

Database DB Reporting Report reports

Part numbers: PC-518564-429299 518564-429299 PC-518564-429300 518564-429300 PC-518564-429301 518564-429301 PC-518564-429302 518564-429302 PC-518564-429303 518564-429303 PC-518564-429304 518564-429304 PC-518564-429305 518564-429305 PC-518564-429306 518564-429306 PC-518564-429307 518564-429307 PC-518564-429308 518564-429308 PC-518564-429309 518564-429309 PC-518564-429310 518564-429310 PC-518564-429311 518564-429311 PC-518564-429312 518564-429312 PC-518564-429313 518564-429313 PC-518564-429314 518564-429314 PC-518564-429315 518564-429315 PC-518564-429316 518564-429316 PC-518564-429317 518564-429317 PC-518564-429318 518564-429318 PC-518564-429319 518564-429319

Mfr. Part No: P72U10M0 P72U10M12 P72U10M24 P72U10M36 P72U1M0 P72U1M12 P72U1M24 P72U1M36 P72U5M0 P72U5M12 P72U5M24 P72U5M36