Options

Ignore securities

feiyinfeiyin Posts: 3
edited May 12, 2006 11:48PM in SQL Compare Previous Versions
When compare 2 dbs on different servers, I don't want to compare logins/users. I have tried using ignoreusers option (in API), but the generated script still try to create logins, is there any way I can totally ignore securities when I compare? thanks
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    edited May 15, 2006 5:01AM
    Hello,

    I suspect that what you want to do is ignore user and role objects as well. you can do this by setting their .selected properties to 'false' when you are in the bit of code that loops through all of the differences and sets the .selected property to 'true'.
    · Share on Twitter
  • Options
    feiyinfeiyin Posts: 3
    Thanks, it works fine now
    · Share on Twitter
This discussion has been closed.