How can we improve SQL Compare?

Manage indexes separately from tables

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.

105 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

15 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    I certainly could use this option today as we are upgrading an huge application and knowing City created indexes missing from the upgraded system would be very helpful

  • Anonymous commented  ·   ·  Flag as inappropriate

    With the number of client databases we're supporting, testing, refactoring, missing indexes is the issue most often. This tool with the index-only option would be a 100% improvement, in our environment. Makes me sick going through the output line by line to find missing indexes.

  • Garrett commented  ·   ·  Flag as inappropriate

    This would be helpful when you only want to sync the indexes and don't want to worry about the other differences. I've had this need several times when copying data for development use.

  • Ankita Patel commented  ·   ·  Flag as inappropriate

    this option is highly required to compare missing indexes between dev and Prod server .

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is much needed feature when i only have to deploy the indexes of one database to another. Going through each table definition to identify the index difference is a very tedious job and wastes a lot of time.

  • Mike Boyle commented  ·   ·  Flag as inappropriate

    This feature would really be useful I actually could not believe I had to go thru each table to look for index differences. Hope this feature will exist in very near future.
    Thanks
    Mike

  • Ian commented  ·   ·  Flag as inappropriate

    Having bought SQLCompare for my client a few months ago but not had a reason to use it in anger until now, I just spun it up assuming that comparing indexes would be a feature, and somewhat shocked that it's not!

    Please do what you can to include it ASAP as it's so important to compare database indexing when trying to work out why one database is outperforming another.

    Ian

  • Kiran commented  ·   ·  Flag as inappropriate

    this is definitely a must have feature in redgate schema compare

  • AdminSam Blackburn (Admin, Redgate) commented  ·   ·  Flag as inappropriate

    We've merged several requests into this one, as they all request that Compare treat indexes as separate objects (with some minor variations). We intend to do some user research in this area in the next few months, at which point we'll try to email you about the feature.

  • James Penman commented  ·   ·  Flag as inappropriate

    We often have a requirement to create bespoke indexes in live databases, however currently a SQL Compare deployment will remove these indexes. It would be good if we could filter out certain indexes, or just prevent those in the destination database from being dropped.

  • SC commented  ·   ·  Flag as inappropriate

    I've just hit this very scenario myself, needing to merge optimisation changes back from a development to a production branch where the table schema has changed. I have to do it manually because otherwise I destroy the existing table schema before the changes are ready for production. This would be super super helpful.

  • Dre Alicea commented  ·   ·  Flag as inappropriate

    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.

  • Dustin Szelong commented  ·   ·  Flag as inappropriate

    When one wants to build, rebuild or stage a database in a step-based fashion (like we often did in the old days with master scripts), it would be nice to leverage SQL Compare to aid in generating/deploying such scripts. The classic example is the desire to drop and re-add keys for data migration/ETL scenarios, so that one can TRUNCATE and bulk load. Currently, I maintain my own master scripts for this reason. So it would be nice, too, to propagate this into SQL Source control's tracking behavior, too!

  • Jens Meyer commented  ·   ·  Flag as inappropriate

    Options to select what type of differences to deploy, e.g. data types, primary keys, constraints, foreign keys, indexes, ...

Feedback and Knowledge Base