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)
· Share on Twitter

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!
    · Share on Twitter
  • Alice EAlice E Posts: 108
    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
    · Share on Twitter
Sign In or Register to comment.