Include or Exclude a specific Index?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Include or Exclude a specific Index?

Postby anna.p » Fri Aug 23, 2013 3:15 am

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:

Code: Select all
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:

Code: Select all
ALTER TABLE TableA ALTER COLUMN Col1 int NOT NULL
CREATE INDEX IDX_Index1 ON TableA (Col1)
anna.p
 
Posts: 23
Joined: Tue Jul 03, 2012 10:59 pm

Postby Brian Donahue » Tue Aug 27, 2013 11:54 am

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
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby anna.p » Tue Aug 27, 2013 6:16 pm

Too bad.
Thanks for the reply.
anna.p
 
Posts: 23
Joined: Tue Jul 03, 2012 10:59 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests