Red Gate forums :: View topic - Can v10 compare unique indexes and ignore other indexes?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Can v10 compare unique indexes and ignore other indexes?

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
drw



Joined: 01 Aug 2011
Posts: 2

PostPosted: Wed May 02, 2012 10:19 pm    Post subject: Can v10 compare unique indexes and ignore other indexes? Reply with quote

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

http://www.red-gate.com/MessageBoard/viewtopic.php?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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Mon May 07, 2012 10:53 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group