New Table columns not being added in the correct order.

benlevy

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 D

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