Options

comparewith optione

rocktheboatrocktheboat Posts: 4
edited August 3, 2006 10:37AM in SQL Toolkit Previous Versions
hello,
I use the toolkit to compare two databases to make them equal.
I would like to skip the users, want to leave them out of the synchronisation. Now a user on the target database is deleted when he does not exist on the source database.
thanks in advance

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    This isn't too terribly hard to do. Just change the 'selected' property on all users and roles to false:
    foreach (Difference difference in differences)
    			{
    				//make sure the difference is selected so it is included in the synchronization
    				if (difference.DatabaseObjectType==ObjectType.User || difference.DatabaseObjectType==ObjectType.Role) difference.Selected=false; 
    				else difference.Selected=true;
    			}
    
Sign In or Register to comment.