Comparison Fails Between Table Indexes

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Comparison Fails Between Table Indexes

Postby JYoder » Fri Sep 23, 2011 10:41 pm

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?
Posts: 3
Joined: Fri Sep 23, 2011 10:24 pm

Postby Linda Hawksworth » Mon Sep 26, 2011 11:15 am

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.
Linda Hawksworth
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests