How to exclude users from comparison?

gflores · December 30, 2017 10:03PM

I've checked Ignore Permissions, user properties, users' permissions and role memberships but the comparison keeps showing me users that exist in prod db that don't exist in our dev db. How can I filter these out? I can do so in VS Data Tools.

I'm using Sql Compare 13.1 (the UI - eventually I'll transition to command-line)

David Atkinson · December 30, 2017 10:09PM

Have you tried using filters? These can also be passed in to the command line using /filter.

gflores · December 30, 2017 10:11PM

Now I feel like an idiot - I didn't know that filter sidebar existed.

Thanks, that's exactly what I needed!

David Atkinson · December 30, 2017 10:16PM

No worries. You're certainly not the first! Once this sidebar disappears, it's hard to know that it's available. This is a UX issue on our end that needs some further thought. Glad that it's what you were looking for.

MLysons · January 16, 2025 2:39PM

Oh. My. Goodness.

That solves that problem

How to exclude users from comparison?

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk