| Author |
Message |
TetonSig
Joined: 06 Jan 2012
Posts: 21
|
 Posted: Mon Feb 13, 2012 4:40 pm Post subject: 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. |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Wed Feb 15, 2012 9:00 pm Post subject: |
|
|
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 |
|
|
TetonSig
Joined: 06 Jan 2012
Posts: 21
|
| Posted: Wed Feb 15, 2012 10:35 pm Post subject: |
|
|
| Thanks for the response |
|
| Back to top |
|
|
|
|
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
