Camunda upgrade 7.11 to 7.15

Camunda 7 Topics Discussion & Questions
1

Hi Guys,

I am doing an upgrade from 7.11 to 7.15
Unable to find the path of MySQL scripts to do the schema changes
Can someone please share the path or from where I can download it?
I have pulled a docker image of camunda 7.12 to start with, using the following command
docker pull camunda/camunda-bpm-platform:7.12.0
couldn’t find any SQL scripts inside the container.
Any info on this is much appreciated.

Thanks

2

Sure, you can find the scripts you’ll need here:
https://docs.camunda.org/manual/7.15/update/patch-level/#database-patches

3

Thank you very much for your prompt reply.
Yes, I have already found this link but unable to download the SQL script because only the name is mentioned.
I am using the Camunda community edition now and I am aware patch level updates are not available for the community edition.

For me to upgrade from 7.11 to 7.12

  1. Should I use the below script?

    image
    image1440×198 25.2 KB

  2. I can only see its name, from where can I download this script?
    Patch Level Update | docs.camunda.org

4

Hello @tinfoilhat ,

this maven dependency will provide every script needed:

<!-- https://mvnrepository.com/artifact/org.camunda.bpm.distro/camunda-sql-scripts -->
<dependency>
    <groupId>org.camunda.bpm.distro</groupId>
    <artifactId>camunda-sql-scripts</artifactId>
    <version>7.15.0</version>
</dependency>

Hope this helps.

Jonathan

1 Like
5

Hi Jonathan,

Is there a way to extract the SQL file from this maven dependency?
We have deployed Camunda in Kubernetes so that plan of action to upgrade is to

  1. Run the database SQL scripts on the database
  2. Pull the newer Camunda image and deploy

Could you tell me if this is the best approach?
Thanks

6

Hello @tinfoilhat ,

you could also download this as zip and extract it.

Your approach then should work. Please always back up the current database before running migration.

Also, I would recommend you do it step-by-step:

  1. Update to 7.12.0
  2. Start engine in 7.12.0
  3. Update to 7.13.0
  4. Start engine in 7.13.0
    …

Jonathan

7

Thanks, Jonathan for the clarification.

One quick question.
Inside the SQL directory, there are 3 other directories called
1.create
2.drop
3.upgrade
Since I am doing only an upgrade, I need to execute the SQL scripts placed inside the upgrade directory right?

8

Hello @tinfoilhat ,

this is correct. They just contain the delta scripts between the versions. Also, do not forget to use patch scripts that migrate between minor versions.

Jonathan

9