Formatting multiple SQL files at once

sql_beagle

I have a folder of hundreds of sql files that I need to format to have a semicolon, as the terminating semicolon is not mandatory in SQL Server.

Is there a way to use SQL Prompt to update files in mass?  I don't see a command line option for running this tool on a set of SQL files in a folder.

Thank you so much.

Jon_Kirkwood

Hi @sql_beagle

 

Thank you for reaching out on the Redgate forums regarding your SQL prompt bulk formatting question.

SQL Prompt is able to conduct bulk operations through SSMS & the command-line; however, these do require a SQL Toolbelt or SQL Toolbelt Essentials license to access.

An overview of bulk operations and licensing requirements can be accessed here:

https://documentation.red-gate.com/sp/features-available-only-in-sql-toolbelt-essentials-and-sql-toolbelt/bulk-operations

And subsequent pages for SSMS & CLI:
https://documentation.red-gate.com/sp/features-available-only-in-sql-toolbelt-essentials-and-sql-toolbelt/bulk-operations/bulk-operations-in-ssms
https://documentation.red-gate.com/sp/features-available-only-in-sql-toolbelt-essentials-and-sql-toolbelt/bulk-operations/bulk-operations-via-the-command-line
 

If you are wanting to trial the toolbelt and these automation functions; I would recommend reaching out to our sales team through sales@red-gate.com to obtain a suitable license to access the bulk functionality.