(Note: I tweeted this to @KickAssSupport but I think it needs a longer explanation...)
My question, broadly, is: Is there a way to see items in a SQL Compare project that are selected and also identical?
This is my scenario:
1. Let's say I make modifications to objects A, B, and C in my development database.
2. I create a SQL Compare project and select A, B, and C. I save this project, "ChangesForProjectX.scp". I am not ready to deploy these changes, I just want to make sure my SQL Compare project is ready when I am.
3. At some later point, I decided I don't need the changes to B, so I remove them from my development database.
If I open up ChangesForProjectX in SQL Compare, I see two items selected: A and C. That looks fine.
What I can't see is that ChangesForProjectX still has B selected-- I just can't see that because B is identical between development and production. Nor can I deselect it. As far as I can tell, the project just has A and C.
The problem that comes up is that I'll be maintaining my ChangesForProjextX project, and then one day (seemingly) out of the blue, object B shows up as a selected object, because someone else made a change to B.
This causes us some grief because we use the SQL Compare project as something of a build set that is maintained over time, but there's no accurate way to tell what is selected-- the only thing you can see is which objects will get synced as a result of the selection applied to the current database state.
Looking at it closer, this may be a more complicated issue because I see you actually are persisting the selection state of groups too-- which makes it even harder to evaluate what's selected. (E.g. When there are four roles that differ and all four are selected, is this the result of having explicitly selected each of the four roles, or of having select the "roles" group?)
I guess what I'm requesting is a way to view-- either on screen or via a report, which items are selected, as opposed to the implications of those selections on the current source/destination combo.