we plan to run Sitefinity for many years and for sure we will have new modules/changes to modules and other things over the years.
I am learning the following:
a) If I use more than one webserver, I need to push the configuration to the database since otherwise configuration changes are only written to one of the webservers, not all of them. As far as I understand it, this is not Azure-specific.
b) If I push the configuration to the database I have no chance to merge the live and local configurations. Cloning the live-DB and using it in development is fine for content but is all configuration really the same?
Are there and solutions to this dilemma? Could we put the file in an Azure Cloud Storage? Or do I really need to use an SQL-Server diff-tool to push/merge changes manually?
This is our first sitefinity project and so far we are really happy with the functionality. but deployment continues to be a major headache. I would love to hear stories from other users how you've setup your deployment in a load-balanced/azure environment.
Release date is drawing near and I would love to have a "fear-free" deployment process. Right now this seems to be light-years away :(