ALTER index vs DROP when alter is possible

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

ALTER index vs DROP when alter is possible

Postby sebling » Mon Jan 14, 2013 10: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!
sebling
 
Posts: 15
Joined: Fri Jun 17, 2005 3:48 pm

Postby Brian Donahue » Tue Jan 15, 2013 12:07 pm

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

Postby james.billings » Tue Jan 15, 2013 5: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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests