Comparison Fails Between Table Indexes

Forum for users of SQL Packager database archive utility

Comparison Fails Between Table Indexes

Postby JYoder » Fri Sep 23, 2011 9: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 9:24 pm

Postby Linda Hawksworth » Mon Sep 26, 2011 10: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 10:32 am

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests