Refactors and formats SQL code.
Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson
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 10:07 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.
- Posts: 692
- Joined: Mon Apr 20, 2009 3:53 pm
- Location: Cambridge
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,
- Posts: 7
- Joined: Tue Aug 29, 2006 6:47 pm
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.
Red Gate Software
- Posts: 1124
- Joined: Mon Dec 05, 2005 4:54 pm
- Location: Twitter: @dtabase
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 1:34 pm
Return to SQL Refactor 1
Who is online
Users browsing this forum: No registered users and 0 guests