Activity overview
Latest activity by andersom
SDC 8 shows DBs as identical, SDC 7 finds differences?
I assume I must be doing something wrong on the command line, but I can't figure out what it might be.
The following command shows the two DBs as identical when using SDC 8:E:\>"E:\Red Gate\SQL ...
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!
SDC selecting from every table in DB. Bug?
So I have some very large databases, in which I'm trying to keep just a couple small tables in sync. This worked fine in SDC7, but after updating to SDC8 it seems that the app insists on selecting ...
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...
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 ...
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.
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.
Enhancement request - Syncing permissions
We have some databases we keep in sync using SQL Compare, however we do not sync the DB users on the destination database.
We currently use the /options:iu,ip in order to ignore users and prevent p...