SQL Pretty Printer について

SQLコードをわかりやすくフォーマットしてデバッグ時間を短縮

SQL Pretty Printer はSQL コードを美しくするのをする、単純にであるにも関わらず、強力な SQL 整形プログラムツールです。ホットキー機能性を使って、 SQL Pretty Printer が Microsoft Query Analyzer, SQL Server Management Studio (SSMS), TOAD やPL/SQL Developer のような多種多様なデータベースツール、 Visual Studio 2003/2005/2008 やEclipse のような開発環境と UltraEditor や EditPlus のようなポピュラーなエディタの SQL 文を再フォーマットすることができます。SQL コードを美しくすることに加えて、 SQL Pretty Printer はSQL コードを C# 、 Java 、PHP、Delphiと他のプログラム言語に変換することができます。

SQL Pretty Printer Benefits

  • No more manual re-formatting - improve SQL readability
  • Enables faster work - use a standard style within your organization
  • No more unnecessary debates about the "right format" - automatic formatting eliminates any disagreements
  • Produce clean SQL for your clients - embed well formatted and syntax colored SQL into your documents
  • Easy integration into your application - add SQL format feature within 5 minutes
  • Cut down SQL debug time - Quickly convert between SQL and C#, Java, etc

SQL Pretty Printer also includes command line functionality, with the ability to format single files, single directories and multiple directories.

SQL Pretty Printer is designed to deal with the syntax used by most popular database systems including Microsoft SQL Server, Oracle, IBM DB2, MySQL and Microsoft Access (Informix, Sybase, and PostgreSQL support is currently in development).

Output conforms to most of the entry level SQL99 Standard.

Add-Ins for SSMS and Visual Studio are available.

APIs for dotnet and COM version are available.

SQL Pretty Printer Features:

  • Beautifies SQL statements utilizing highly customizable format options.
  • Formats SQL on-the-fly in popular tools and editors using hotkey functionality.
  • Minimizes to the system tray for quick access.
  • Includes a command line for batch conversion of single files, single directories or directory trees (use the command line API in your own program!)
  • Verifies SQL syntax with detailed error information.
  • Converts monochrome SQL code into colorful RTF document.
  • Converts monochrome SQL code into colorful HTML for easy placement in blogs and forums.
  • Converts SQL to various programming languages including C#, Java, DELPHI, PHP and others.
  • Currently supports SQL syntax for Microsoft SQL Server, Oracle, IBM DB2, MySQL and Microsoft Access (Informix, Sybase, and PostgreSQL support is currently in development).
  • Add-In for SQL Server Management Studio available.
  • Add-In for Visual Studio available.

Get your favorite layout
With more than 80 format options and still growing,  get your favorite SQL layout, It's never been so easy. switch between different styles with predefined layout templates quickly.

Don't reinvent the wheel
Don't waste time writing a “SQL formatter” feature yourself,  It's already here for your .NET application and any COM enabled programming language such as VB, VC!

Fantastic time saver
Debugging SQL in C#, VB.NET, ASP.NET or any Java program is an extremely time consuming job. Quickly converting between SQL and different programming languages is now made very easy

Efficient and standard
Allows you to switch from team “standard” formatting to individually preferred formatting and back for better uniformity in your source control repository.

Focus on functionality
Just write SQL and focus on functionality, don't worry about how many spaces or tabs need to be used to indent SQL. SQL Pretty Printer will do it for you with just one hotkey.

Be professional
Publish well formatted and colored SQL scripts (in html or RTF) on the web, blogs, forums, articles or books. It will make you look more professional.

SQL Pretty Printer Desktop Version
SQL Pretty Printer Desktop Version allows you to format your SQL wherever you are regardless of your Internet connection. It generates various output formats, including text, colorful html (Used in web, blog, wiki, forums) and RTF.

Batch mode enables you to clean up SQL in multifiles under a nested directory.

While sitting in the tray, you can format SQL in any editor like Microsoft Query Analyzer, UltraEditor or notepad with just one hotkey.

  • Various output formats - Text, Colorful Html, RTF
  • Notepad and Query Analyzer - quick tidy SQL in any editor
  • Command line interface - batch conversion

Add-In for SSMS
Add the ability to format SQL inside SQL Server Management Studio with SQL Pretty Printer Add-In for SSMS. It makes your team more productive by using a uniform layout rule and standardizes SQL in your team. Just click on "Format Selected SQL" or "Format All SQL" and the Add-In will beautify SQL according to your predefined layout rules.

Add-In for Visual Studio
Add the ability to format SQL inside Visual Studio with SQL Pretty Printer Add-In for VS. It makes your team more productive by using a uniform layout rule and standardizes SQL in your team. Just click on "Format Selected SQL" or "Format All SQL" and the Add-In will beautify SQL according to your predefined layout rules. Quickly converting between SQL and C#, VB.NET and vice verser, this will dramatically save your time while debugging SQL in C# or VB.NET.