Red Gate forums :: View topic - Comparison Fails Between Table Indexes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Comparison Fails Between Table Indexes

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JYoder



Joined: 23 Sep 2011
Posts: 3

PostPosted: Fri Sep 23, 2011 10:41 pm    Post subject: Comparison Fails Between Table Indexes Reply with quote

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?
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Sep 26, 2011 11:15 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group