Comments
Sort by recent activity
Perfect, thank you. Looks like I already had the root cert, but was missing the intermediate. Once I had that Change Automation installed just fine. Cheers. / comments
Perfect, thank you. Looks like I already had the root cert, but was missing the intermediate. Once I had that Change Automation installed just fine.Cheers.
Thanks for the help Sergio, most apprciated. It's a shame I can't just ignore the Windows users, I would love to control the SQL logins with the Change Automation project. I don't suppose I could raise it as a feature request for future versions? [image] / comments
Thanks for the help Sergio, most apprciated. It's a shame I can't just ignore the Windows users, I would love to control the SQL logins with the Change Automation project.I don't suppose I could r...
So I've been playing with the filters in SQL Compare 14 in order to create something I can use in the Change Automation projects. When I exclude users from the comparison they are still included in the role definitions, for example <div>-- Role</div><div>CREATE ROLE [EbCollSqlgen]</div><div>AUTHORIZATION [dbo]</div><div>GO</div><div>ALTER ROLE [EbCollSqlgen] ADD MEMBER [ATTENDA-HQ\EbCollSqlgen]</div><div>GO
</div>Do these not get validated then? Will the deploy still fail if the role membership includes Windows users not in the current domain? / comments
So I've been playing with the filters in SQL Compare 14 in order to create something I can use in the Change Automation projects.When I exclude users from the comparison they are still included in ...
Hi Sergio, Thanks for the suggestion. Is there a straight-forward way of excluding only Windows users from the Change Automation project? I would really like to keep the SQL logins in source control so I can keep tabs easily on permissions. For example on the primary database I'm working on there are 10 Windows users and 40 sql logins to keep track of. Cheers, Nick / comments
Hi Sergio,Thanks for the suggestion. Is there a straight-forward way of excluding only Windows users from the Change Automation project? I would really like to keep the SQL logins in source contr...