views:

121

answers:

6

I'm looking for a good T-SQL Pretty Printer so that all the code looks consistent between developers in our project. Preferably a free/open source one, but paid for isn't out of the realms of possibility as long as it's reasonably priced. Are there any particular industry leaders?

I'm not that fussed about what particular standard it uses, but the more configurable the better. That way we can have little style wars among the developers and have a bit of fun to boot. ;-)

I suppose I should add that Visual Studio and Management Studio integration would be considered favourably.

+1  A: 

http://www.sqlinform.com/ (sorry, no Visual Studio Integration, though.)

Tomalak
Looks ok and I'll give it a try shortly, but that integration thing is quite important. I so like staying inside my little ide.
pms1969
A: 

Other than sqlinform, Toad for SQL Server comes with an SQL formatter out of the box, among plenty of other advantages over management studio...

ercan
A: 

I have used SQLInform before for formatting code from different developers in a similar way. Works well.

Galwegian
A: 

Did Any one of You EMS SQL Manager for SQL Server.It's Good.

There are lots of SQL Server Managemnet Studio Alternatives

Imrul
I like LinqPad, but that's not really suitable for what I have in mind. I need to reformat actual t-sql...... now if only sql server was entirely linq based.
pms1969
+2  A: 

SQL Prompt has a code formatter and SSMS + VS integration

thecoop
So far, I think the most promising. I know it comes with a bit more than just formatting, but £157 for what I want (formatting) does seem a little excessive... I shall continue the search, but if nothing better comes up, I think this has it.
pms1969
Nothing better has arrived, so Sql Prompt has it.
pms1969
+1  A: 

I can vouch for the RedGate's products, including SQL Prompt. I use several of their tools, and their support is terrific.

SD