Is there a commandline tool?

Refactors and formats SQL code.

Is there a commandline tool?

Postby kloker » Thu Jun 04, 2009 9:11 am

I have approx. 7000 stored procedures in .sql files. Before i check them in TFS it would have been nice if they were formated the same way.

Thanks in advance!
Posts: 1
Joined: Thu Jun 04, 2009 9:07 am

Postby Anu Deshpande » Thu Jun 04, 2009 10:15 am

Unfortunately SQL Refactor does not have a command line feature. This application only integrates as a plug-in.

The only way you can currently use the SQL Layout feature of SQL Refactor would be if you checked your code in and out of source control system into SSMS.

I know how easy it will be for you if we have command line integration.
So I have added a feature request in our internal tracking system to bring into attention of development team.Unique id for your feature request is SR-722.
I have added a watch on this issue so that I can update you if any development is going on.

Thanks for your patience with this issue.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Postby Michael.Kriegner » Wed Jun 17, 2009 8:37 am

I even would go a step further and make a .net API, which returns a RTF-Text (with colors). So everybody could also very easy write an own commandline tool.

We would need such API for our own .net programs.

Hope you can also add this as request,

Michael Kriegner
Posts: 7
Joined: Tue Aug 29, 2006 5:47 pm

Postby David Atkinson » Wed Jun 17, 2009 8:40 am

Hi Michael,

That's a great idea and we'll definitely include this as a candidate for a future release.

Thanks for the taking the time to give us your feedback.

David Atkinson
Product Manager
Red Gate Software
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Any news?

Postby fro » Mon Mar 15, 2010 12:36 pm


I'm also urgently looking for a way to reformat our 3500+ SPs in batch. Is there any progress on SR-722?

Thanks in advance,

Posts: 1
Joined: Mon Mar 15, 2010 12:34 pm

Postby David Atkinson » Mon Mar 15, 2010 1:06 pm

There is a workaround described in another forum post: ... hp?t=10543

Is this method something you would consider using in the interim?

David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Refactor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests