How can we help you today? How can we help you today?

Feature or a bug?

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
laker_42
0

Comments

2 comments

Sort by
  • laker_42
    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
    laker_42
    0
  • Brian Donahue
    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'.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.