Exclude Logins, Users and Shemas

Automate and integrate using the SQL comparison API

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

Exclude Logins, Users and Shemas

Postby dUros » Thu Feb 27, 2014 5:12 pm

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
 
Posts: 6
Joined: Wed Feb 26, 2014 11:09 am
Location: Slovenija

Postby dUros » Thu Feb 27, 2014 7:53 pm

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
dUros
 
Posts: 6
Joined: Wed Feb 26, 2014 11:09 am
Location: Slovenija


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron