Enforce Identical Column Order

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

Enforce Identical Column Order

Postby adamvaul » Mon Apr 18, 2011 5:55 pm

I think SQL Source Control should enforce identical column ordering, that way we can write a statement such as

SELECT * FROM Table1

And know that if our databases are linked and up to date, we will return columns in the same order every time, no matter which database we use.

As it is now, SQL Source Control does not even recognize a column reordering as a change.

Could RedGate add this to the Source Control technology?

P.S. We just got on board recently and the product truly is amazing.
adamvaul
 
Posts: 3
Joined: Mon Apr 18, 2011 5:48 pm
Location: CA, USA

Postby David Atkinson » Tue Apr 19, 2011 12:11 am

Glad you like the tool. Column order should now be highlighted as a difference. This was a bug that we've now fixed. Could you visit Help/Check for Updates to make sure you have the latest version?

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

Postby adamvaul » Mon Apr 25, 2011 6:16 pm

Yeah Thanks
adamvaul
 
Posts: 3
Joined: Mon Apr 18, 2011 5:48 pm
Location: CA, USA

Postby adamvaul » Mon Apr 25, 2011 6:21 pm

Its working good now, thanks.
adamvaul
 
Posts: 3
Joined: Mon Apr 18, 2011 5:48 pm
Location: CA, USA


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests