Azure SQL vs Umbraco CMS and new application release
Hi.
We have an Umbraco CMS installed as Azure WebApp. It uses two SQL databases.
The question is - what is the best approach for updates/deployments?
We have a code stored in Github and Hashicorp's GoCD as Continuous Integration server. For code there is no problem at all - we just use MSDeploy to update web.config and copy files.
But what about SQL databases? We have a DEV environment, which has some media and localization updates. It includes database changes. Obviously - we can't just switch PROD to STAGE databases, as PROD have updates from some external users, and STAGE - have changes, which is not applied to PROD yet.
I'm looking on to "Synchronize" facility - but not sure this is the correct way.
Azure SQL vs Umbraco CMS and new application release
Hi.
We have an Umbraco CMS installed as Azure WebApp. It uses two SQL databases.
The question is - what is the best approach for updates/deployments?
We have a code stored in Github and Hashicorp's GoCD as Continuous Integration server. For code there is no problem at all - we just use MSDeploy to update web.config and copy files.
But what about SQL databases? We have a DEV environment, which has some media and localization updates. It includes database changes. Obviously - we can't just switch PROD to STAGE databases, as PROD have updates from some external users, and STAGE - have changes, which is not applied to PROD yet.
I'm looking on to "Synchronize" facility - but not sure this is the correct way.
Any tips appreciated.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.