SQL Compare SDK removing users from database

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

SQL Compare SDK removing users from database

Postby chris.brown » Mon May 20, 2013 3:02 pm

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.
chris.brown
 
Posts: 2
Joined: Mon May 20, 2013 2:54 pm

Solution

Postby chris.brown » Tue May 21, 2013 4:08 pm

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.
chris.brown
 
Posts: 2
Joined: Mon May 20, 2013 2:54 pm


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 1 guest