Is there a commandline tool?

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Is there a commandline tool?

Postby kloker » Thu Jun 04, 2009 10: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!
Mathias
kloker
 
Posts: 1
Joined: Thu Jun 04, 2009 10:07 am

Postby Anu Deshpande » Thu Jun 04, 2009 11: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.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Michael.Kriegner » Wed Jun 17, 2009 9: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
Michael.Kriegner
 
Posts: 7
Joined: Tue Aug 29, 2006 6:47 pm

Postby David Atkinson » Wed Jun 17, 2009 9: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: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Any news?

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

Hi,

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,

Frank
fro
 
Posts: 1
Joined: Mon Mar 15, 2010 1:34 pm

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

There is a workaround described in another forum post:

http://www.red-gate.com/MessageBoard/vi ... hp?t=10543

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

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


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests