Competition: What’s your favorite Redgate tool? Enter now.

Is there a commandline tool?

klokerkloker Posts: 2
edited March 15, 2010 9:06AM in SQL Refactor Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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: [email protected]
  • 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
  • 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
    Product Manager
    Redgate Software
  • 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
  • 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
    Product Manager
    Redgate Software
Sign In or Register to comment.