Feature or a bug?

laker_42

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

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 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'.