Dropping a user is a potentially dangerous operation.
delli
Posts: 5
hi
I've setup our automated deployment to promote our code from Dev to Live, at present we nly want to synchronise the following:
-Views
-Functions
-Store procedures
-Synonyms
All goes well until we get to Octopus deploy that is correctly pickup up the artifact and run SQL release to get the changes that will be promoted to our UAT. We have deliberately not checked in users as we don't want our deployment solution setting up users on our Test and Prod environment. When the compare engine runs it is comparing the uses and trying to drop them from UAT because it releases they don't exists. I've tried all the command line options on https://documentation.red-gate.com/display/SC11/Options+used+in+the+command+line but none have had the desired effect. I know you can do this on the SQL Compare front end but I can't figure out how to get release to behave in the same way.
Many Thanks
Ian
I've setup our automated deployment to promote our code from Dev to Live, at present we nly want to synchronise the following:
-Views
-Functions
-Store procedures
-Synonyms
All goes well until we get to Octopus deploy that is correctly pickup up the artifact and run SQL release to get the changes that will be promoted to our UAT. We have deliberately not checked in users as we don't want our deployment solution setting up users on our Test and Prod environment. When the compare engine runs it is comparing the uses and trying to drop them from UAT because it releases they don't exists. I've tried all the command line options on https://documentation.red-gate.com/display/SC11/Options+used+in+the+command+line but none have had the desired effect. I know you can do this on the SQL Compare front end but I can't figure out how to get release to behave in the same way.
Many Thanks
Ian
Comments
You should be able to create a filter file that excludes users and use this filter with SQL Release. Here's the documentation page which details how to do this - https://documentation.red-gate.com/disp ... QL+Release
I hope this helps.
Redgate Software
I've ready through the link you sent but according to the web page it said:
The code we have checked into TFS was through the Redgate SQL SourceControl addin and a Filters file is present in our NuGet package, my understanding was the options I selected in SourceControl would influence what objects are actually compared in SQL release. We don't want have to setup a separate filter file otherwise filter options we change SourceControl wont automatically take affect.
Regards
Ian
I'm going to create a support ticket for you. You should receive an email shortly.
Redgate Software