Tidy for SQL

views:

425

answers:

+2 Q:

I'm looking for a tool that that I can use to clean up (formatting, tabs etc...) my stored procedures and views. Is there anything like html's tidy, but for SQL which is free/open source?

+1 A:

Here is one option.

http://www.dpriver.com/

http://www.wangz.net/sqlpp/vsaddin.html

Daniel A. White 2009-07-07 15:45:38

This is kind of what I'm looking for, but it looks like its an online app, I'd like to have something that I can hook into locally and integrate with an existing application.

Rob 2009-07-07 15:54:00

Website is free to use, but the add-in for SSMS is $40 USD.

Rick 2009-07-07 22:44:48

+3 A:

ssmstools is useful

gbn 2009-07-07 15:46:52

I just installed this and its a very useful tool kit. +1

Rob Allen 2009-07-07 15:52:45

Thanks, its shaping up to be a great tool for me. Just a word to the wise. This program will now work unless you have SP2 installed.

Rob 2009-07-09 07:40:11

I use Instant SQL Formatter occasionally, it does the job for me.

2009-07-07 21:02:06

Website is free to use, but the add-in for SSMS is $40 USD.

Rick 2009-07-07 22:43:48

You could try the free Simple Talk Prettifier:

http://www.simple-talk.com/prettifier/

It's basic but might satisfy your requirements.

David Atkinson 2009-10-27 17:38:46

an ssms 2005/2008 addin: http://code.google.com/p/sqlformat/

it lacks some features but it is very a good start

yioann 2010-04-24 15:39:00

ansaurus

tags:

views:

answers:

Tidy for SQL

related questions