I am currently using EE2.1.3 - having recently upgraded from 1.6.8.
I am working in staged environments called “dev”, “uat” and “production”. Previously we would deploy our template updates as DB dumps, but we decided to embrace the “save templates as files” functionality in EE2.
My goal has been to deploy template updates as SVN tags and to thereby bypass the DB updates altogther.
Templates are now saved as file which is great, however a problem has arisen in relation to the “metadata” which is stored in the “exp_templates” table.
There are a few “metatdata” fields for templates which are only stored in the DB, eg:
allow_php, php_parse_location, template_type.
So, the problem is: when I add new a template which has custom settings for PHP parsing, the new template is created (using “SVN update”) but the metadata is not carried though from dev to uat (and hence must be manually updated).
This is not such a big deal when going from dev to uat - but when updating production it would mean that the pages needing these settings would be broken for a time.
Of course I have considered just dumping and importing the template DB tables - but this is effectively what we were doing before and what we were hoping to avoid by saving templates as files.
I’m trying find out if there are other developers out there who have engaged with this problem and found a solution or a good workaround.
Thanks!