Comments
Sort by recent activity
Anyone care to share their set-up and experience with automated deployments? / comments
Anyone care to share their set-up and experience with automated deployments?
In the build task, have you ticked the box "Append BuildId to the NuGet package version"? That gives us a new nupkg for each build and we then reference a particular nupkg in our releases by appending "$(BUILD.BUILDID).nupkg" to the Database Package field. / comments
In the build task, have you ticked the box "Append BuildId to the NuGet package version"? That gives us a new nupkg for each build and we then reference a particular nupkg in our releases by append...
Have you tried using a migration script to control how the deployment is executed? https://documentation.red-gate.com/soc6/common-tasks/working-with-migration-scripts / comments
Have you tried using a migration script to control how the deployment is executed? https://documentation.red-gate.com/soc6/common-tasks/working-with-migration-scripts
Ah, thanks Praveen! / comments
Ah, thanks Praveen!
Strange that it is trying to drop the user in that case, have you checked what differences are being identified if you use SQL Compare - useful to get a different view of things when there's a problem like this. We have created AD accounts for each environment we deploy to (Test, PreProd, Prod) and set them up as the user for TFS Agent Queues to run under. In our TFS database releases, we use the relevant queue for the environment and grant the AD account relevant permissions on the database(s) in that environment so we're using Windows Authentication throughout. No-one can therefore use the Test TFS Agent Queue to deploy to a Production database. We exclude all users from source control using a filter so we don't get into the situation of having a Development user deployed to a Production database when it shouldn't be. If we need to amend users/permissions then this needs to be scripted separately - we find this an easier solution than trying to somehow deploy specific users to specific environments. / comments
Strange that it is trying to drop the user in that case, have you checked what differences are being identified if you use SQL Compare - useful to get a different view of things when there's a prob...
Hi Serge, the deployment is doing a comparison of objects in your source control and your target database so this suggests that the user is not in source control (correctly in my view) so will want to drop it from your target database. You can set up a filter in SQL Source Control to exclude all users (or just this user) and the deployment won't try to drop the user. / comments
Hi Serge, the deployment is doing a comparison of objects in your source control and your target database so this suggests that the user is not in source control (correctly in my view) so will want...
There is a table named DDLEvents in my RedGate database into which events are inserted for DLM Dashboard via a server level trigger. See info here: https://documentation.red-gate.com/ddb1/about-the-dlm-dashboard-server-objects. / comments
There is a table named DDLEvents in my RedGate database into which events are inserted for DLM Dashboard via a server level trigger. See info here: https://documentation.red-gate.com/ddb1/about-the...
How are you trying to install the framework? There isn't an object named dbo.DDLEvents in the framework as far as I can see. / comments
How are you trying to install the framework? There isn't an object named dbo.DDLEvents in the framework as far as I can see.
Both of those methods to edit a test are working ok for me - in SSMS 17.4. / comments
Both of those methods to edit a test are working ok for me - in SSMS 17.4.
Sorry, don't get distracted by the file path, this was for SQL Compare. Have you tried this method and it doesn't work? / comments
Sorry, don't get distracted by the file path, this was for SQL Compare. Have you tried this method and it doesn't work?