What are the challenges you face when working across database platforms? Take the survey

Alter only indexes

codecode Posts: 11
edited April 25, 2007 8:48AM in SQL Compare Previous Versions

Please forgive me if this has been asked before but I'd like to update only indexes and make no changes to table definitions i.e columns etc.

I know this could have implications if indexes are being created on columns that do not exist but I will be making sure this does not happen.

I couldn't see any options to only include constraints and indexes in the final SQL script that is generated.

Many thanks if anyone can help.


  • Options

    Is there any chance I would be able to do something like this with SQL Compare?

    Many thanks
  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5

    Thank you for your post into the forum.

    This option does not exist in SQL Compare.

    You cannot compare just Indexes or constraints as objects on their own in the manner you are seeking using SQL Compare.

    To compare and view the differences in your Indexes or Constraints, you must compare the tables and views that use the Index or constraint.

    Many Thanks

    Eddie Davis
    Technical Support Engineer
    Red Gate Software Ltd
    E-Mail: support@red-gate.com
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.