Does not see reordering of columns in table as change

mattbreeze

Hi there,

I am using SQL Compare 9.0.0.79 and I tried synchonising two databases both having a table called Test. In the first database the table is defined:

CREATE TABLE [dbo].[Test]
(
[a] [int] NULL,
[int] NULL
)

in the second database it is defined:

CREATE TABLE [dbo].[Test]
(
[int] NULL,
[a] [int] NULL
)

SQL Compare saw the two objects as identical, even though they are not. Please help!

David Atkinson

There is a 'force column order' option you can enable when you edit your project. Please try this and let us know if this does what you require.

Kind regards,

David Atkinson
Red Gate Software