What Free SQL Formatting Tools Exist

Is there a free SQL formatting library for .NET?

I don't know about a free version, but there is one here for only $100 and you can try it for 60 days (choose the API version).

http://www.dpriver.com/buynow.php

It's not free, but at $100, it's probably less than 2 hours of your time trying to find/integrate a free one

Is there an sql reindenter?

My favorite: http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz

Pretty Printer for T-SQL?

SQL Prompt has a code formatter and SSMS + VS integration

Best T/SQL Formatting Add-In for SQL Server Management Studio

I came across this tool:

http://www.apexsql.com/sql_tools_refactor.asp

It's pretty good for a free product. Nothing beats the Red Gate tools however.

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

Create the folder

%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\

if it does not exist. Then just copy the file from:

%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn

to

%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn

Tidy for SQL

Three years later, I'd just like to round out this question with two options that seem to be missing, and I think are both more appropriate than most options listed so far:

• Poor Man's T-SQL Formatter / poorsql.com (free, open-source, SSMS add-in, commandline formatter, full DDL/DML script formatting, and I'm the author/maintainer so I get to put it first :))
• T-SQL Tidy (free, SSMS Add-In, full DDL/DML script formatting, apparently 2008R2 add-in can do offline formatting also now - but not open-source?)

I believe either of these makes more sense than any of the previous answers because the other options provided are:

• Online-only (instant sql formatter)
• Trialware / commercial software (sql pretty printer)
• Don't format (SSMS tools pack, the accepted answer)
• Don't handle full T-SQL properly (CPAN module, SQL-talk prettifier)
• Incomplete, only handle some statements (SqlFormat project)

Are there any platform agnostic SQL query builders with syntax, logic formatting etc.?

I've used SQLInform in the past with pretty good results - again it formats any SQL you paste in with reasonable accuracy.

---

Related Topics