Unnecessarily dropping indexes when table will be dropped
TetonSig
Posts: 27
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.
On larger tables this makes deployment scripts take much longer than they should.
Comments
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.