Include or Exclude a specific Index?

Forum for users of SQL Compare schema synchronization utility

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: 6590
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 Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests