Red Gate forums :: View topic - Exclude Logins, Users and Shemas
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Exclude Logins, Users and Shemas

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dUros



Joined: 26 Feb 2014
Posts: 6
Location: Slovenija

PostPosted: Thu Feb 27, 2014 5:12 pm    Post subject: Exclude Logins, Users and Shemas Reply with quote

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.
Back to top
View user's profile Send private message AIM Address
dUros



Joined: 26 Feb 2014
Posts: 6
Location: Slovenija

PostPosted: Thu Feb 27, 2014 7:53 pm    Post subject: Reply with quote

Hello again.

I solve my problem Very Happy .

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
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group