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

Comments

  • David AtkinsonDavid Atkinson Posts: 1,389 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.