Command Line "Reformat All Files In Folder" and pre-Commit
Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.
Many of Red Gate's tools provide command-line functionality.
Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).
Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.
Stephen
shared this idea
Bulk operations for formatting and code analysis were added as part of SQL Prompt 10.7
-
Joshua Ferguson
commented
Yes please!!
-
John Tunnicliffe
commented
This would be a perfect addition to the SQL Prompt functionality!
-
SAinCA55
commented
Old code was infrequently schema qualified.
We need a simple "Perform Ctrl+B, Ctrl+Q on all .sql files in this folder tree"
Can you imagine manually doing that for 4500 procedures?
2 years have passed, and sadly no traction, despite ApexSQL Refactor having a command-line capability for free...
-
Matthias Vill
commented
With the new formatting-style options this is even of more interest to us.
-
Harish Supe
commented
Would really useful when you inherit large repository of SQL code from legacy systems/company merger/acquisition.
-
Brandon Warner
commented
Much needed feature!
-
Matthias Vill
commented
Sound similar to https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/8196585-command-line-reformat-all-files-in-folder-and-pr (more votes there)
-
KJ
commented
It would be wonderful if, as with SQL Complete, I could apply SQL Prompt formatting to a directory of files. Even better is if I could specify the file extension, whether or not to recurse through sub-folders, and whether or not I want the file to remain open in SSMS after applying formatting.