Is there a commandline tool?

kloker

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

Anu D

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.

Michael.Kriegner

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

David Atkinson

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

fro

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

David Atkinson

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