Update DB Schema in Combination with Blue-Green Deployment

[nocin]

Hi,

via #427 I found the new content related to DB schema updates.
In this section are two new topics for me. First, that you can update the DB schema using cds-mtx update, and second, that you can combine this with Blue-Green Deployment. I have two question on that.

I would like to setup up Blue-Green Deployment for our Multitenant application, but we are not using a sidecar, means we are not using cds-mtx.

The command must be run in the MTX application / sidecar root directory with the application environment.

Does cds-mtx update work, when not having a sidecar?

And is there any more content related to CAP and Blue-Green Deployment?
The only post I found in this community is this one, which raises the question, what happens if a DB model upgrade fails? Is there any rollback? From my understanding this is not possible, because the previous live version is deleted, when setting the idle version productive.

It would really help, if the CAP docs can be enhanced on this topic.

Thanks!
Nico

[renejeglinsky]

Hi @nocin ,

Thanks for raising this question. I'll get back to you soon after reCAP.

[renejeglinsky]

Hi @nocin ,
I'm picking this up now and let you know about the progress.
Thanks,
René