Ignore Indexes option DOES synchronize indexes

RedGARRedGAR Posts: 3 Bronze 2
edited June 16, 2008 7:58AM in SQL Compare Previous Versions
When I use "Ignore Indexes" (in Project Configuration > Options) the index differences do not show up, as expected, but they do turn up in the synchronization script. Is there anything I overlook?

(SQL Compare 6.2.0.271)

Comments

  • RedGARRedGAR Posts: 3 Bronze 2
    Response from RedGate: "placed it into the bug database for the Red Gate development team placed as SC-3890".

    Thanks guys!
  • Just to clarify this point a little:
    There is a bug in SQL Compare where if the synchronisation process involves dropping an index, the index will be dropped; regardless of whether or not the Ignore Indexes option has been turned on.

    Unfortunately SQL Compare doesn't yet work out which situations are safe to retain the index, but hopefully this issue will be looked at for a future release.

    Alice Easey
    Red Gate Software
Sign In or Register to comment.