Is it possible to apply a format style to multiple files at once?

KevinCust

Currently trialing SQL Prompt Pro 9 in Visual Studio 2017.

Is there a way to apply the chosen formatting style across a whole SSDT project rather than just one file at a time?
I'd like to do this as a once off starting point for some legacy code as a single git commit.

Maybe there is a command line for the formatter which I could code up in some powershell to walk the folder structure or something?

I couldn't find a native way in the menus to apply a style to anything other than the current file. (I'm a new user as of yesterday, so I might be missing something)

Jessica R

Hi @KevinCust,

There isn't a way to do this at the moment, I'm so sorry to say.

We have a similar request on our uservoice forum here: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/8196585-command-line-reformat-all-files-in-folder-and-pr

Can you kindly vote on the request? (Our developers use it as a resource when deciding new features.)

KevinCust

Jessica R wrote: »

Hi @KevinCust,

Can you kindly vote on the request? (Our developers use it as a resource when deciding new features.)

I did vote on that request the other day after I posted the question, but that request is about 2.5 years old and only 20 votes with no official feedback on whether it is being considered.

I'm assuming it is not going to be in a release any time soon, if at all. So I'll need another solution for what I'm trying to do.

Jessica R

Really sorry that SQL Prompt doesn't have this feature at the moment!

I passed your feedback directly to our developers and while there still isn't a decision on this particular request, they are planning on doing more regular reviews of the uservoice forum next year and will update the request if anything changes.