ALTER index vs DROP when alter is possible

Forum for users of SQL Compare schema synchronization utility

ALTER index vs DROP when alter is possible

Postby sebling » Mon Jan 14, 2013 9:49 pm

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!
Posts: 16
Joined: Fri Jun 17, 2005 2:48 pm

Postby Brian Donahue » Tue Jan 15, 2013 11:07 am

I have logged a support call for you with reference F0068435. We will be in touch shortly.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby james.billings » Tue Jan 15, 2013 4:13 pm

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests