Include or Exclude a specific Index?

anna.p

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)

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.

anna.p

Too bad.
Thanks for the reply.