Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

When tables have different number of indexes the compare will show differences when in reality the indexes are the same, just not aligned.

A table on server 1 has 2 indexes. The same table on server 2 has 4 indexes. Depending on the order that the script generates the DDL the compare might show all 4 indexes as different/new where it should show 2 as the same and 2 new.

89 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Shaya Gindoff shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ben Sacheri commented  ·   ·  Report

    It seems like some of these issues can be resolved if SQL Compare would sort the indexes before performing the comparison.

    I have two indexed fields on a table. It's telling me there is a difference but it's simply showing the two fields in a different order. Duh!

  • Rick Thorington commented  ·   ·  Report

    Why is this still a problem in 2020?
    Please fix sorting/alignment!

    SQL Compare 14.2.0.14846

  • Daniel White commented  ·   ·  Report

    This is a general problem not confined to just indexes. For another example, if two stored procedures are the same except for spacing and the placement of the line breaks, the differences pane highlights much code that is not actually different.

  • Dan Tibbs commented  ·   ·  Report

    Yeah, this is a pain. I always end up having to specify only the table containing the index differences and generating a deployment script to confirm what will happen if deployed in regard to the indexes. In many cases several items are highlighted in the difference pane, with crazy alignment that is hard to follow. Upon generating the script I can see what is going to happen and it doesn't seem to match what is displayed in the difference pane...