Does not see reordering of columns in table as change

mattbreezemattbreeze Posts: 2
edited May 2, 2011 4:47AM in SQL Compare Previous Versions
Hi there,

I am using SQL Compare 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!


  • Options
    David AtkinsonDavid Atkinson Posts: 1,441 Rose Gold 2
    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
    Product Manager
    Redgate Software
Sign In or Register to comment.