Exclude Logins, Users and Shemas

dUros

I have problem with Users, Logins and shemas in differences script.

I don't know how to completly exclude (ignore) this type of objects in comparing.

Thanks.

dUros

Hello again.

I solve my problem .

After differences = compareWith(.....) I made Loop Like Loop in worked example in chm file.

But I put IF inside Loop like in example below:

For Each difference In stagingVsProduction
If difference.DatabaseObjectType.ToString = "Role" Or difference.DatabaseObjectType.ToString = "User" Or difference.DatabaseObjectType.ToString = "Schema" Then
difference.Selected = False
Else
difference.Selected = (difference.Type.ToString = "Different")
End if
Next

I hope it will help anyone else.

Regards