[TYPO3-core] TYPO3 CMS Deployment with code and database

[Peter Niederlag]

Hi,

On 18.03.2015 23:22, Simon Schaufelberger (Schaufi) wrote:
> Hi Loek,
[...]
> I thought about a hook that will be executed on every db change (insert,
> update, delete) in the TYPO3 backend which will eventually write the sql
> changes to a file which then can be deployed. That would be the cleanest
> way imho.

A hook to me sounds like it is likely to break rather easy and produce
wrong update statements.

You could write a Tool that would compare old and new records and create
proper "UPDATE" Statements. Basically just about the same as the Backend
now is working when updating records in BE. Just across different
databases/dumps.

You would trade of the x seconds downtime agains y seconds data
inconsistence. Not sure if transactions could help.


[...]

Greets,
Peter