Column reordering is not detected for commit

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

Column reordering is not detected for commit

Postby garthd » Thu Mar 17, 2011 10:13 pm

Shared Mode
Using SVN

On a table that was previously committed I moved a column from being the last to being the fourth column. However, when I attempted to commit the change was not detected.

I worked around it by directly editing the SQL file in SVN
Posts: 1
Joined: Thu Mar 17, 2011 3:57 pm

Postby David Atkinson » Fri Mar 18, 2011 12:21 am

Column ordering is currently not considered a 'difference' from a source control point of view, but due to popular demand we're changing this very soon.

Thanks for pointing this out. Please let us know if there are any other behavioral changes that are required.

Kind regards,

David Atkinson
Product Manager
Red Gate Software
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Postby csmith » Tue Feb 21, 2012 2:43 pm


SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options to be configured.

To get this version, please run Check For Updates from the Help menu in SQL Source Control. This is a free upgrade for existing licensed v3 users and for users with a Support & Upgrades contract.

Comparison options can now be set via a configuration file in your database repository's Working Base folder. The following Knowledge Base support article describes how to configure this option:
KB201202000521 - Setting SQL Compare options within SQL Source Control

Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.

If you'd like to see an options dialog exposing these settings in SQL Source Control, please vote on the associated Idea on our UserVoice site. It'd be great if you could also leave a comment indicating which specific options you'd like to see in the dialog.

Best regards,
Chris Smith
Project Manager
SQL Lighthouse
Posts: 120
Joined: Thu Jun 30, 2011 1:15 pm
Location: Cambridge

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests