How to filter User, Roles and Schemas when compare using Compare SDK

GerardoS

Hi,

I am trying to Compare 2 database but I need to ignore the User, Roles and Schema using Code (C# or VB).
I tried
stagingDB.Register(sourceConnectionProperties, Options.Default.Plus(Options.IgnoreUsers, Options.IgnoreUserProperties))
Also tried
stagingDB.Register(sourceConnectionProperties, Options.Default.Except(Options.IgnoreUsers, Options.IgnoreUserProperties))

But it always compare.
Maybe I need to filter in some way but I dont know how.

Any help with be very good.

Thanks.

AshaPatel

Hi Gerardo,

I'm sorry to hear you're hitting this problem!

You are correct in your understanding how the filters work. Setting Options.Default.Plus(Options.IgnoreUsers, Options.IgnoreUserProperties) should indeed ignore any Users and UserProperties differences. I have raised an internal bug report CSD-220 for investigation; we shall update you when we have made any progress.

Again, sorry you encountered this!

Thanks,
Asha

GerardoS

I used the Object RedGate.SQLCompare.Engine.Filter and was able to filter.

Thanks.