SQL check Scritpt for schema validation

Camunda 7 Topics Discussion & Questions
1

Hey guys,

how can I check that my camunda database schema is valid. after upgrading from 7.2, 7.3, … it could be possible that we have forgotten some constraints. A script that checks the database with a given version number for a valid defninition would be nice.

Maybe as cockpit function ?

Greetings.

Carsten

2

Hi @cpiepel,

there are no scripts existing right now to perform a check. One way you could approach this is to:

  • do migration
  • do the dump of schema
  • download packaged distribution
  • start against clean database
  • do the dump of schema
  • compare 2 dumps with simple diff tool

depending on your database there might exist more sophisticated approaches of course.

Hope that helps,
Askar

3