Activity overview
Latest activity by brookal
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...
SQL Change Automation with EF Core code first database/entities
I have created a set of entity classes using EF Core and going to create a code first database. I have used SQL Change automation in the past with a database first architecture but what is the bes...
SQL Change Automation requires .NET Framework 4.7.2 or later
All I can is "thanks a lot Red-gate" for stuffing up my build processes....A day of development wasted yesterday. It was only after a bit of searching the forums to find that you have broken my bui...
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...
deploying data updates with SQL Change Automation
I was wondering how it should be configured or the best practices for using data update scripts with SQL Change Automation.The scenario is that I need to add columns or tables as part of a database...
Where has SQL Change Automation gone in Visual Studio 2017
I have just done an upgrade of all my red-gate products via the toolbelt installer as well as my Visual studio 2017 installation and now SQL Change Automation has completely disappeared. There is n...
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...
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...
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