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
0

Comments

3 comments

  • David Atkinson
    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
    0
  • adamvaul
    Yeah Thanks
    adamvaul
    0
  • adamvaul
    Its working good now, thanks.
    adamvaul
    0

Add comment

Please sign in to leave a comment.