Apply formatting on commit

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Apply formatting on commit

Postby simonjmartin » Thu Oct 13, 2011 8:12 am

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]
Posts: 11
Joined: Thu Oct 13, 2011 8:05 am

Postby eddie davis » Mon Oct 17, 2011 9:49 am

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 Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1145
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby David Atkinson » Mon Oct 17, 2011 11:09 am

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
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests