Unnecessarily dropping indexes when table will be dropped

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

Unnecessarily dropping indexes when table will be dropped

Postby TetonSig » Mon Feb 13, 2012 4:40 pm

Is there an option or other way to have SQL Compare just script a table drop without scripting index/constraint drops as well?

On larger tables this makes deployment scripts take much longer than they should.
TetonSig
 
Posts: 21
Joined: Fri Jan 06, 2012 10:45 pm

Postby chriskelly » Wed Feb 15, 2012 9:00 pm

This option isn't available in SQL Compare.

You could output the synchronization script and edit it, but I am struggling to see why this would be beneficial (after the initial performance benefit) because you could end up with lots of old constraints being idle and just taking up space.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby TetonSig » Wed Feb 15, 2012 10:35 pm

Thanks for the response
TetonSig
 
Posts: 21
Joined: Fri Jan 06, 2012 10:45 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests