Apply formatting on commit

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Apply formatting on commit

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

Postby eddie davis » Mon Oct 17, 2011 10: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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby David Atkinson » Mon Oct 17, 2011 12:09 pm

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: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests