Feature or a bug?

laker_42laker_42 Posts: 47
edited February 25, 2007 1:35PM in SQL Compare Previous Versions
We had the same tables in our dev db & our production db. We added a column in the dev db after the third column. When I did a compare & synched up the two, it added the new column to the end of the existing columns. Is it supposed to be functioning this way? If so, is there an option to be set so it keeps this order intact? This will mess up inserts in SPs that use these tables. Here's an example just to make sure it is clear what I said:

Dev:
Table
Col1
Col2
ColNew
Col3

Prod:
Table
Col1
Col2
Col3
ColNew

Thanks,
John

Comments

  • I want to use the force column order option, correct? Is there a way to set this option globally so every new comparison project will have this option checked?

    I guess I should have done a little more homework before posting! :oops:
    John
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi John,

    The workaround would be to create a project with the desired setting and use it as a template. Then you can right-click it and 'create clone'.
Sign In or Register to comment.