Chiara, thank you for posting an update. In our team's case, we have multiple databases which were developed without SQL coding standards. We would like to be able to export the schema using SQL Compare (create a scripts folder), then run a command line tool to format all the files using a custom SQL Prompt style we've standardized on. Then we will update the databases using those scripts and update source control with the same scripts. That way going forward, all scripts and changes follow a standard and if we diff two files in source control, it's easy to see what's changed. If we format files as we change them, then it's not clear when you diff the files what changes are formatting changes and what changes are functional.

I will ask our sales rep about SQP Prompt For Teams. Please contact me if you have additional questions.

2020 has now passed, do we have an update for this feature request?
By the looks of it, a lot of people are asking for it so would be nice to have a status update.

Very useful to have it for code review.

Would love to be able to format all files in a format and qualify object names in each one.

A feature to update multiple files at once is a definite hole in SQL Prompt. Other tools provide this feature for free. It is one of the biggest wins for competing products when evaluating SQL Prompt.

@SAinCA_Mi9 If developers are running this from local dev machines then the SCA license doesn't apply, so that could be an option.

@David_Atkinson - thanks for the pointers, BUT, "To run code analysis as part of an automated process, such as continuous integration, a SQL Change Automation license is required." Thus, with everything running on SIX Dev databases concurrently, manually performing this is a non-starter, and purchasing another license, likewise.

@Tim - VERY SAD to hear this. I guess that 62 votes isn't enough of a crowd. Especially given that typical Uservoice participation is on the low side for any product, thus, at 62, you probably have a good representative sample for "NEEDED feature". We'll be watching, but breaths won't be held. FOUR YEARS will become FIVE YEARS by the time this even sees a PLAN, it seems... Oh well, disappointment is becoming the norm.

@Stephen - Alhought the SQL Code Guard SSMS add-in has been retired in favour of SQL Prompt, you can still use the SQL Code Guard command line to run SQL Prompt's code analysis rules. https://documentation.red-gate.com/scg/sql-code-analysis-documentation/code-analysis-for-sql-server-command-line

With SQL Code Guard no longer a viable product, and its functionality re rules is now within SQL Prompt, isn't this a compelling argument for BOTH "Format all Files" AND " Run Code Analysis using <this> set of Rules". For compliance, we will have to do this, and we are now, FOUR YEARS ON from my original post, at 6,792 SQL Modules. Utterly untenable as a manual task. Please, BUMP THIS UP THE FEATURE STACK A.S.A.P., with thanks.

<Please do this:D>
With command line and / or API batch formatting it will be possible to integrate a formatting step into GIT check in so all files checked into source control have the same formatting applied automatically, by policy.
</Please do this:D>

This is really a must feature for those of us who review code of others and from many groups and places. Attempting to compare old to new code when it is not formatted using the same options is almost impossible. Now multiply it times hundreds of files in a review. We currently use another product which does some of the job but does not have the all the functionality of SQL Prompt. Do we buy more SQL Prompt or the other product? It would be nice to know if this is a planned feature or not so we can make a decision.

This is preventing me from pulling the trigger on the purchase. I can't do 2000+ files one at a time. Competitor has free tool that does this.

We need to format the Files in the Folder also.

We desperately need this feature! Being able to automate SQL formatting would make pull requests so much easier.

Please add this feature!

To be serious about source control code should be formatted on commit. This requires a basic command line interface.

Our team desperately needs this option as well. Could also be a command-line option as well

please please add this

This feature is a must, currently having to powershell through the objects, open then CTRL K+Y, CTRL B+Q which means opening up over 2000 objects 1 at a time.

I echo the "daunting" sentiment of the original post.

I'm currently working through 1000 files.

Ideally would prefer a command line option so that I could apply a git-hook to this task, but a single GUI operation would also be acceptable.

Actually opening each file before re-formatting then saving is extremely time-consuming.

Alternative products already do this!