ALTER index vs DROP when alter is possible

seblingsebling Posts: 22
edited January 15, 2013 11:13AM in SQL Compare Previous Versions
When changing rebuild index options e.g. ALLOW_PAGE_LOCKS is it possible for SQL Compare to generate an ALTER INDEX REBUILD WITH rebuild index options rather than a drop and create?
Would simplify deployments to replicated tables when a DROP and CREATE are not strictly required.
Thanks - your products are my lifeline!
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I have logged a support call for you with reference F0068435. We will be in touch shortly.
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    Hi Steve,
    I've had a quick look and don't see an option that may help here, and I also don't spot an existing request for it either.

    I'm happy to log it in our internal bugtracker but could I ask you to send over a "before" and "after" table definition that triggers the behaviour you're wanting to avoid so the development team are understanding you correctly? You can post that here, or mail it in on your ticket (F0068435 in the subject line).

    You may also want to add it to our Uservoice site for SQL Compare so other users can vote-up the change.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.