Does not see reordering of columns in table as change
mattbreeze
Posts: 2
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!
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
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software