Options

SQL Compare SDK removing users from database

chris.brownchris.brown Posts: 3
edited May 21, 2013 11:08AM in SQL Comparison SDK Previous Versions
When I compare my database with a database creation script created from a VS 2010 data-tier application project, the users are removed my database.

In the dta project, I have defined a database role, but there are no users as these are created within the installer in which SQL Compare SDK is implemented.

In my code I have set the options IgnoreUsers and IgnoreUserProperties but I can't stop the users being removed.

Has anyone come across this problem and/or know any solution?

Thanks.
· Share on Twitter

Comments

  • Options
    chris.brownchris.brown Posts: 3
    The solution to this issue is to loop through the objects in the database, ensure you set all the users .Selected = false then the SQL compare will completely ignore them.
    · Share on Twitter
Sign In or Register to comment.