SQL Prompt 4.0 release notes
Published 12 February 2013
August 10th, 2009
- 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.
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. Redgate offers two free tools that help migrate snippets and aliases from v3.9. For more information, please see the following forum posts:
Snippet migrator: http://www.red-gate.com/MessageBoard/viewtopic.php?t=9361
Alias importer: http://www.red-gate.com/MessageBoard/viewtopic.php?t=9362
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.