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

Does not see reordering of columns in table as change

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!
mattbreeze
0

Comments

1 comment

  • 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
    David Atkinson
    0

Add comment

Please sign in to leave a comment.