SQL Prompt Bundle について

Microsoft SQL ServerのエディターにIntelliSense機能を追加

SQL Prompt Bundle には、SQL Prompt、SQL Doc、SQL Data Generator、SQL Refactor が組み込まれています。SQL Prompt は、シームレスな IntelliSense 型の自動補完やレイアウトの機能を提供します。SQL Doc を使用するとデータベースに接続して、MS-Word や HTML フォーマットでドキュメントを出力することができます。SQL Data Generator は、実際のテスト データを備えたデータベースを自動的に事前設定します。SQL Refactor を使用すると、SQL コードやデータベース オブジェクトを選択したスタイルで自動的に書式設定することができます。

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 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 Doc - Document SQL Server 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

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

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.