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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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'.
  • Thanks, it works fine now
This discussion has been closed.