I need to upgrade the Camunda version 7.13 to 7.17.
Went through some documentation and found that there are some patch-level DB updates.
Ref: Patch Level Update | docs.camunda.org
Can someone clarify if it is required to run the patches level-wise (for each version)?
Or if I can have one script for directly upgrading from 7.13 to 7.17?
And what happens to the existing process instances data ?
the db patches have to be applied in the correct order.
I would recommend to clone the database, run a patch, test if it works (by executing tests on the database). If everything is alright, you can apply the path to your production system as well. Repeat this for each patch. I know this is a very defensive approach, but as the database is the heart of the process engine, you should also treat it like a heart.
But no fear: These patches should work without any problem as long as you have not customized your schema (adding or removing custom fields, indices, constraints and other dirty stuff).
These patches will update the schema while respecting constraints and integrity of data. So basically nothing would happen to your process data.