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
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
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 11:32 am
Return to SQL Packager 6
Who is online
Users browsing this forum: No registered users and 0 guests