| Author |
Message |
drw
Joined: 01 Aug 2011 Posts: 2
|
Posted: Wed May 02, 2012 10:19 pm Post subject: Can v10 compare unique indexes and ignore other indexes? |
|
|
I asked this question about SQL Compare 9, and the response was "hopefully we can implement it in a future version."
http://www.red-gate.com/MessageBoard/viewtopic.php?t=13834
Basically, we would like to compare our development database with our production database, synchronize primary keys, unique constraints, and unique indexes, and ignore non-unique indexes.
Primary keys, unique constraints, and unique indexes are functionally significant, are created by the developer on the development database, and need to be deployed to production.
Non-unique indexes only affect performance, are maintained by an administrator directly on the production database, and must not be created or dropped just because they don't match what's in development.
So, is there any chance that SQL Compare 10 will compare unique indexes and ignore non-unique indexes? |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6345 Location: Red Gate Software
|
Posted: Mon May 07, 2012 10:53 am Post subject: |
|
|
Implementing a feature depends on how many people ask for it vs the amount of work involved to do it. I have to admit using this formula, it looks pretty unlikely at this point. _________________ Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| 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