How can we help you today? How can we help you today?

Unnecessarily dropping indexes when table will be dropped

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
0

Comments

2 comments

Sort by
  • chriskelly
    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
    0
  • TetonSig
    Thanks for the response
    TetonSig
    0

Add comment

Please sign in to leave a comment.