What are the challenges you face when working across database platforms? Take the survey
Options

Exclude Logins, Users and Shemas

dUrosdUros Posts: 21 Bronze 1
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.

Comments

  • Options
    dUrosdUros Posts: 21 Bronze 1
    Hello again.

    I solve my problem :D .

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