Comments
Sort by recent activity
Would it be possible to use the standard VS2019 migrations to create a local dev database being monitoring by the DLM dashboard as a safety check. After that, can I then create a deployment project to create/deploy the change scripts to my integration and production databases. / comments
Would it be possible to use the standard VS2019 migrations to create a local dev database being monitoring by the DLM dashboard as a safety check. After that, can I then create a deployment projec...
Thanks for the information . I can confirm that I am currently using SQL Change Automation so that my scripts can be deployed as part of the build and release pipelines in VSTS. The post deployment folder seems like a good place but, obviously I need to ensure that data update scripts are only run once. / comments
Thanks for the information .I can confirm that I am currently using SQL Change Automation so that my scripts can be deployed as part of the build and release pipelines in VSTS.The post deployment f...
Hi Greg, I have now managed to sorting out the build pipeline to use the change automation task and it works again.... However, I couldn't get the Azure hosted2017 agent to use an Azure SQL database as the shadow database... something to do with permissions for cleaning etc... However, as I have a build agent in a VM, I have continued to use that. Can you double check that the pipeline works correctly with an Azure SQL database as the shadow database. I have created the empty database in the Azure portal, but the pipeline fails and then the database is deleted for some reason. Alan / comments
Hi Greg,I have now managed to sorting out the build pipeline to use the change automation task and it works again.... However, I couldn't get the Azure hosted2017 agent to use an Azure SQL database...
Hi Greg, I have now spent the day changing my build pipeline to use the redgate sql chnge automation build task so we shall see what we have with that Alan / comments
Hi Greg, I have now spent the day changing my build pipeline to use the redgate sql chnge automation build task so we shall see what we have with thatAlan
Hi Greg, What would be a good version number to use in this slot. Alan / comments
Hi Greg,What would be a good version number to use in this slot.Alan
Hi Greg, That explains it then [image] Many thanks for the update... Do you know how to get the sql change automation into the Azure DevOps pipeline... I have installed it via the marketplace but I don't seem to be able the add it into my pipeline as there is no Add button. [image] / comments
Hi Greg,That explains it then Many thanks for the update... Do you know how to get the sql change automation into the Azure DevOps pipeline... I have installed it via the marketplace but I don't se...
Can you use an Azure SQL database as a shadow database as I don't understand how to configure it. I can't use the localDB option as I think I use a text catalog in my database which is not supported by SQLlocalDB. I apologise for all the questions but I can frantically trying to get our build pipeline working again so that I can generate a release. / comments
Can you use an Azure SQL database as a shadow database as I don't understand how to configure it. I can't use the localDB option as I think I use a text catalog in my database which is not support...
I would also be very interested in this being a new feature in DLM dashboard / comments
I would also be very interested in this being a new feature in DLM dashboard