SQL Prompt Bundle

SQL Prompt Bundle Updated:

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 Bundle includes:

• SQL Prompt Pro: seamless IntelliSense-style code completion and layout
• SQL Doc: fast database documentation in Word or HTML
• SQL Data Generator: automatically populate databases with realistic test data
• SQL Refactor: a host of smart refactorings on the fly

SQL Prompt - Intelligent code completion and layout for MS SQL Server

• 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 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 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 works with Visual Studio 2005 and 2008, Query Analyzer, SQL Server Management Studio 2005 and 2008, and SSMS Express Edition.
Visual Studio Team System 2008 Database Edition GDR is not supported.

SQL Doc - Document SQL Server 2000,2005 and 2008 databases

• Create database documentation directly from your schema
• Add descriptions to tables, views, and columns
• Export documentation to HTML or Microsoft Word format
• Includes all internal and cross-database dependencies
• Supports SQL Server 2000, 2005, and 2008

SQL Doc is a fast, simple tool that allows you to connect to your databases and write, edit, and output documentation in easy-to-read HTML or as printable Microsoft Word documents. SQL Doc automatically includes information about object definitions and dependencies, and allows you to add further descriptions to your database objects if necessary.

This stand-alone documentation tool is ideal for developers who need to produce documentation for their databases and want to produce high quality output with minimum effort.

SQL Data Generator - Test data generator for MS SQL Server databases

• Data generation in one click
• Realistic data based on column and table name
• Data can be customized if desired
• Eliminates hours of tedious work
• Full support for SQL Server 2008

Quickly create test data
SQL Data Generator intelligently creates realistic test data by automatically taking the table and column names into account, along with field length and any existing constraints. After all, you wouldn't want your coffee mug filled with dishwater.

Privacy legislation prohibits the sharing of live sensitive data. So if you want to demo your database to a client or develop your production database, SQL Data Generator can quickly replace the live data with realistic test data so that people will probably not even notice you've made the switch.

Whether you want to future-proof your database by populating it with large quantities of additional data and testing to see if it scales or breaks, or you simply need some starter data to highlight potential improvements to your new schema, SQL Data Generator will automate the tedious, allowing you much more time to run lots of creative tests.

Data can be pulled in from existing data sources and if you really want to show off to your boss or clients the data can be easily customized.

SQL Refactor - Refactor and format your SQL code

• Update all dependant objects when you rename tables, views, and procedures
• Expand wildcards and qualifying object names to improve quality and performance
• Summarize complex SQL scripts
• 11 refactorings in total

SQL Refactor allows you to automatically format your SQL code and database objects in the style of your choice. SQL Refactor improves the quality of your code, making it easier to read, understand and share amongst a team. A companion tool to SQL Prompt, SQL Refactor dramatically speeds up database development and administration, without impacting on the behavior of your database and applications.

SQL Refactor comes with a full set of 11 refactorings

Lay Out SQL, to format your code (with over 30 options)

Working with legacy SQL code means untangling someone else's coding format and quickly interpreting the purpose of the script. SQL Refactor provides a range of one-click features that instantly make legacy code as easy to work with as your own, including Layout SQL, Summarize Script, Encapsulate as a New Stored Procedure, and many more.

Smart Rename, for objects: Tables, Views, Stored procedures, User-defined functions

• Smart column rename for views and tables
• Smart parameter rename for procedures and functions
• Split Table, can also create referential integrity tables
• Uppercase Keywords
• Summarize Script
• Expand Wildcards in SELECT statements
• Qualify Object Names
• Find Unused Variables and Parameters
• Encapsulate As New Stored Procedure

SQL Refactor is an add-in to Management Studio and works with SQL Server 2000, 2005, and 2008