Apply formatting on commit

simonjmartin · October 13, 2011 4:12AM

I would like to be able to auto format anything in a commit, as a means of quickly and consistently laying out all scripts.

Each developer has their own style and layout habits and trying to retrospectively update the entire back catalogue of stored procedures, udf's etc. is a monumental task. So instead I would like to be able to specify that whenever code is committed that it is 'run through a standard SQL Prompt' code organisation. Of course each developer should do this themselves and I know we can share the style definitions but it's "one more thing" to remember, so automating it (or having the option available if the computer has both SQL Source Control and SQL Prompt installed) would be awesome [/i]

Eddie D · October 17, 2011 5:49AM

Thank you for your post into the forum.

I have submitted a feature request for formatting to be automatically applied when performing a commit.

I cannot guarantee that the feature request will be successful. Or if approval is given, what future version of the product the requested feature will appear in.

Thank you very much for your suggestion.

Best Regards
Eddie

David Atkinson · October 17, 2011 7:09AM

Simon - this is a great idea. Are there any other checks you'd like done to the code before or while it is being committed?

David Atkinson
Product Manager
Red Gate Software

Apply formatting on commit

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk