How can we help you today? How can we help you today?

Include or Exclude a specific Index?

Is it possible to "include", "exclude" or filter by a specific index or constraint?

For example, let's say these are the differences between source and target:
ALTER TABLE TableA ALTER COLUMN Col1 int NOT NULL
CREATE INDEX IDX_Index1 ON TableA (Col1)
CREATE INDEX IDX_Index2 ON TableA (Col2)
And these are the changes I actually want to push:
ALTER TABLE TableA ALTER COLUMN Col1 int NOT NULL
CREATE INDEX IDX_Index1 ON TableA (Col1)
anna.p
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi Anna,

    SQL Compare treats indexes as attributes of a table, so it's not possible to have the sort of granularity where you can push changes to a subset of indexes on a table.
    Brian Donahue
    0
  • anna.p
    Too bad.
    Thanks for the reply.
    anna.p
    0

Add comment

Please sign in to leave a comment.