Comparison Fails Between Table Indexes

JYoder

In comparing 2 DBs, one has this line in the table for an index...

CREATE NONCLUSTERED INDEX [idx_Name] ON [dbo].[TABLE1]([EmployeeKey]) INCLUDE([DeductionKey], [CheckKey])

and the other DB's table of the same name has this...

CREATE NONCLUSTERED INDEX [idx_Name] ON [dbo].[TABLE1]([EmployeeKey]) INCLUDE([CheckKey], [DeductionKey])

The only difference is the order of the fields at the end. How can it detect them as a difference and recreate the table?

Linda Hawksworth

I am sorry to hear you are having problems with SQL Compare. The behaviour you are seeing has been reported by other users and is logged in our tracking system with reference SC-4165. I have added your comments and ticket reference to the issue and will be informed if/when the status changes.