Disabled index issue
It looks like the disabled flag inon indexes is not taken into account when comarign tables in v220.127.116.1132.
If I create the same table on both the source and target database and then run the commented out "disable" line of code on either the source or the target then SQL compare will not flag the index as different.
CREATE TABLE dbo.RGTest (ID INT IDENTITY(1, 1) NOT NULL , IndexedFiled CHAR(5) NOT NULL , CONSTRAINT PK_RGTest PRIMARY KEY CLUSTERED (ID ASC) ON [PRIMARY]) ON [PRIMARY]; GO CREATE NONCLUSTERED INDEX IX_RGTest_IndexedField ON dbo.RGTest ( IndexedFiled ASC ) ON [PRIMARY]; GO --ALTER INDEX IX_RGTest_IndexedField ON dbo.RGTest DISABLE;
0 · Share on Twitter