Unnecessarily dropping indexes when table will be dropped

Forum for users of SQL Compare schema synchronization utility

Unnecessarily dropping indexes when table will be dropped

Postby TetonSig » Mon Feb 13, 2012 3: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 9:45 pm

Postby chriskelly » Wed Feb 15, 2012 8: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.
chriskelly
 
Posts: 371
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

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

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


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests