Ability to select individual indexes
DreTheDBA
Posts: 3
When comparing tables, additions/changes in indexes are included as part of the differences to the table. I would like a way to separate index management from table management. In other words, it would be nice to be able to select a table for modification without including the indexes. I know we can do this from a project level with settings, but if there are many tables selected for change, I would like to be able to include the indexes for some tables and not others. Also, it would be nice to be able to select individual indexes on a given table. Sometimes multiple indexes would display for a given table and it would be nice to hand pick which indexes are being selected for promotion.
Comments
As you noted there is the option to "Ignore indexes" - but it ignores all indexes so it is not selective.
If you would like to selectively deploy indexes I highly suggest you add that idea to our UserVoice Feature Request forum available here https://redgate.uservoice.com/forums/141379-sql-compare
I have also followed up with you via email for further Q&A.
Kind Regards,
Technical Sales Engineer
Redgate Software