Red Gate forums :: View topic - Unnecessarily dropping indexes when table will be dropped
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Unnecessarily dropping indexes when table will be dropped

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
TetonSig



Joined: 06 Jan 2012
Posts: 21

PostPosted: Mon Feb 13, 2012 4:40 pm    Post subject: Unnecessarily dropping indexes when table will be dropped Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Wed Feb 15, 2012 9:00 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
TetonSig



Joined: 06 Jan 2012
Posts: 21

PostPosted: Wed Feb 15, 2012 10:35 pm    Post subject: Reply with quote

Thanks for the response
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group