SQL Compare SDK removing users from database

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?



  • 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.
Sign In or Register to comment.