Forum for users of SQL Packager database archive utility
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
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.
- 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