Comments
Sort by recent activity
Looks like that fixed the problem. Thanks! / comments
Looks like that fixed the problem. Thanks!
Excellent, thanks for the reply! / comments
Excellent, thanks for the reply!
Ah, I believe I've solved my problem. The issue was that I did not want users or logins synced to the destination DB, but do want roles and role permissions synced. When I executed the sync command using /options:d,iu, the "include dependancies" inherent in the "d" option was what was messing things up. I changed my options to if,iw,ifg,iup,iweo,iu,irpt and everything seems to be working properly now.
For reference, my full command-line is thus: "E:\Red Gate\SQL Compare 6\SQLCompare.exe" /verbose /exclude:user /exclude:schema /exclude:StoredProcedure:sp_MS* /options:if,iw,ifg,iup,iweo,iu,irpt /server1:x /server2:y /database1:z /database2:z /sync
This results in syncing tables and roles, and granting permissions to the roles, but excludes users and logins as desired. / comments
Ah, I believe I've solved my problem. The issue was that I did not want users or logins synced to the destination DB, but do want roles and role permissions synced. When I executed the sync command...
I'm going to feel rather foolish if the solution to my issue is already in place and that simple. Let me give it a try and get back to you ;-) / comments
I'm going to feel rather foolish if the solution to my issue is already in place and that simple. Let me give it a try and get back to you ;-)
No, I'm finding that ip is ignoring permissions granted to roles. iu is working just fine. / comments
No, I'm finding that ip is ignoring permissions granted to roles. iu is working just fine.
Nope, excluding the ip doesn't work. See the following excerpt from the log: Altering permissions on [dbo].[SomeTable]
Msg 15151, Level 16, State 1, Server XXXXX, Line 1
Cannot find the user 'SomeUser', because it does not exist or you do not have permission.
See, because the users don't exist on the destination, omitting ip results in permission setting failing, causing the entire process to fail. / comments
Nope, excluding the ip doesn't work. See the following excerpt from the log:Altering permissions on [dbo].[SomeTable]
Msg 15151, Level 16, State 1, Server XXXXX, Line 1
Cannot find ...
No, iu is working just fine, the issue is that I want to be able to ignore only user permissions and not role permissions. Currently iu ignores all permissions, so I don't have that flexibility. / comments
No, iu is working just fine, the issue is that I want to be able to ignore only user permissions and not role permissions. Currently iu ignores all permissions, so I don't have that flexibility.
Ok, thanks for the response. I should be able to work around the limitation by outputting to a script file and calling osql. / comments
Ok, thanks for the response. I should be able to work around the limitation by outputting to a script file and calling osql.
the complete output is: E:\Red Gate\Jobs>"E:\Red Gate\SQL Compare 6\SQLCompare.exe" /verbose /exclude:us
er /exclude:role /exclude:schema /options:iw,iweo,iu,iup,irpt /server1:the_real_
trsprodb /server2:ladbtrsmo01\latrsmom /database1:trsncp /database2:trsncp /sync
SQL Compare Command Line V6.0.0.1410
==============================================================================
Copyright c Red Gate Software Ltd 1999-2007
Serial Number:
SQL Compare running with option: IgnoreWhiteSpace (OK).
SQL Compare running with option: IgnoreWithElementOrder (OK).
SQL Compare running with option: IgnoreUsers (OK).
SQL Compare running with option: IgnoreUserProperties (OK).
SQL Compare running with option: IgnoreReplicationTriggers (OK).
Registering databases
Creating mappings
Comparing
Replaying user actions
Comparing database the_real_trsprodb.trsncp with database ladbtrsmo01\latrsmom.t
rsncp...
Creating SQL
Synchronizing databases
Error: Error Comparing the_real_trsprodb/trsncp vs ladbtrsmo01\latrsmom/trsncp :
Incorrect syntax near the keyword 'create'. Incorrect syntax near 'end'.
E:\Red Gate\Jobs>
that's with the verbose option. Is there a debug option that I could use that would give more output? / comments
the complete output is:E:\Red Gate\Jobs>"E:\Red Gate\SQL Compare 6\SQLCompare.exe" /verbose /exclude:us
er /exclude:role /exclude:schema /options:iw,iweo,iu,iup,irpt /server1:the_real_
trsprodb ...
Also, to answer your question; it will not be possible to send DB snapshots in this case due to sensitive data. / comments
Also, to answer your question; it will not be possible to send DB snapshots in this case due to sensitive data.