How can we help you today? How can we help you today?

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

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.
GerardoS
0

Comments

2 comments

Sort by
  • 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
    AshaPatel
    0
  • GerardoS
    I used the Object RedGate.SQLCompare.Engine.Filter and was able to filter.

    Thanks.
    GerardoS
    0

Add comment

Please sign in to leave a comment.