Can v10 compare unique indexes and ignore other indexes?

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

Can v10 compare unique indexes and ignore other indexes?

Postby drw » Wed May 02, 2012 10:19 pm

I asked this question about SQL Compare 9, and the response was "hopefully we can implement it in a future version." ... hp?t=13834

Basically, we would like to compare our development database with our production database, synchronize primary keys, unique constraints, and unique indexes, and ignore non-unique indexes.

Primary keys, unique constraints, and unique indexes are functionally significant, are created by the developer on the development database, and need to be deployed to production.

Non-unique indexes only affect performance, are maintained by an administrator directly on the production database, and must not be created or dropped just because they don't match what's in development.

So, is there any chance that SQL Compare 10 will compare unique indexes and ignore non-unique indexes?
Posts: 2
Joined: Mon Aug 01, 2011 7:12 pm

Postby Brian Donahue » Mon May 07, 2012 10:53 am

Implementing a feature depends on how many people ask for it vs the amount of work involved to do it. I have to admit using this formula, it looks pretty unlikely at this point.
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests