New Table columns not being added in the correct order.

benlevybenlevy Posts: 2
edited December 10, 2009 6:56AM in SQL Compare Previous Versions
I tried to search fot this, but could not find any reference.

Basically, when adding a new column to a table (in the middle somewhere), when SQL Compare updates a DB (from scripts), it adds the column to the end of the table.

The scripts being generated (create scripts) are correct.

Is there a way to make this works seeing as this is fairly common during our dev cycle.


  • Eddie DEddie D Posts: 1,681 Rose Gold 5
    Thank you for your post into the forum.

    Have you tried editing your SQL Compare project and enabling the option to 'Force column order'?

    When this option is enabled, if additional columns are inserted into the middle of the table, this option forces a rebuild of the table so the column order is correct following synchronization. Data held in the table is preverved.

    Many Thanks
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.