In this section:

Domibus database installation and upgrade scripts

1.  Download the latest version of the Domibus database installation and upgrade scripts

Please find the latest version for the Domibus database installation and upgrade scripts here:

2. What changes

As of Domibus version 5.1.1, the SQL scripts for installing or upgrading the Domibus database that were released up to that release together with the Domibus application, are now released separately. They become a separate product that is distinct from the Domibus one.

The release pages of all versions of Domibus as of 5.0 onward were updated to link to the new scripts archive instead of the archive released together with the original Domibus release.

The scripts will follow an independent release cycle and will use semantic versioning starting with version 1.0. The name of the artefact is "domibus-msh-sql-distribution" and will start at version 1.0.

This change was introduced to provide more clarity to users of Domibus regarding:

• the latest version of the SQL scripts to use, regardless of which Domibus version they are installing / upgrading from/to
• which scripts to apply in case the version of the scripts they used contained defects which were fixed

3. Description of the domibus-msh-sql-distribution artefact

3.1.1. Content of the release package

The product is a ZIP archive that will contain a set of SQL scripts as follows:

• clean database installation scripts for all the Domibus versions that were supported at the time of the release of the domibus-msh-sql-distribution artefact (e.g., mysql-5.1.1.ddl)
• incremental upgrade scripts from any version of Domibus to the next version of Domibus; where next version of Domibus is a version of Domibus that was supported at the time of the release of the domibus-msh-sql-distribution artefact (e.g., mysql-5.1-to-5.1.1-upgrade.ddl)
• where defects were detected in a released incremental upgrade script,
  • incremental patch scripts from the incorrect version to the corrected same version (e.g., in case of defects in the mysql-5.1-to-5.1.1-upgrade.ddl script, the script mysql-5.1.1-to-5.1.1-v2-upgrade.ddl will be added to the archive, allowing those who already used the incorrect script to patch their database schema where possible)
  • patched versions of the incremental upgrade scripts from the latest correct version to the corrected next version (e.g., in case of defects in the mysql-5.1-to-5.1.1-upgrade.ddl script, the script mysql-5.1-to-5.1.1-v2-upgrade.ddl will replace the incorrect script mysql-5.1-to-5.1.1-upgrade.ddl in the archive, allowing those who did not already use the incorrect script to directly rely on the corrected one when upgrading)

3.1.2. Location of the release package

The name of the archive will be:

"domibus-msh-sql-distribution"+"-"+version+".zip"

The URL for the location of the ZIP archive in the the code repository will be:

"https://ec.europa.eu/digital-building-blocks/artifact/repository/eDelivery/eu/domibus/domibus-msh-sql-distribution/" + version folder + "/" + archive name

3.1.3. Versioning rules (semantic versioning)

The version number is constructed by concatenating three numbers in the format x.y.z, where x is the major version, y is the minor version, z is the patch version.

3.1.3.1. Patch release

The patch version will be incremented, the minor and major version will remain the same. A patch release will be published each time the scripts are released to fix a defect in the existing scripts but not to address new a release of the Domibus product. As a consequence a patch release will add to the archive a set of "-vX" scripts.

3.1.3.2. Minor release 

The patch version will be reset to 0, the minor version will be incremented, the major version remains the same. A minor release will be published every time there is a new release of the Domibus product. It will contain new clean installation scripts and new incremental upgrade scripts for the freshly released Domibus version, as well as potential corrections of older scripts and/or incremental patch scripts.

3.1.3.3. Major release 

The patch and minor versions will be reset to 0, the major version will be incremented. A major release will be published when a new structure or approach for the product is being implemented.

3.1.4. Release guidelines

• There will be one minor release to follow each Domibus release. This release will cover:

1. • clean installation scripts for the new release
   • incremental upgrade scripts form the previous version to the new release
   • (optional) corrections of older scripts and/or incremental patch scripts
   • (optional) removal of older scripts for or involving Domibus versions that are out of support

• The minor release can be followed by any number of patch releases to cover:

1. • corrections of any of the scripts in the minor release
   • addition of incremental patch scripts
   • removal of older scripts for or involving Domibus versions that are out of support

3.1.5. Access to older scripts

The latest artefact will only contain scripts that create a database schema for one of the supported Domibus versions, upgrade scripts from/to supported versions and upgrade scripts from the most recently out of support Domibus versions to supported ones.

Users who still use older unsupported versions of Domibus and want to upgrade to a supported version or users who would like to install an unsupported version of Domibus may need SQL scripts that are no longer part of the latest artefact. In such cases, users are advised to contact the eDelivery support team.

4. How to use the "domibus-msh-sql-distribution" scripts 

4.1. When doing a clean install of Domibus

Always download the latest version of the scripts irrespective of the version of Domibus you are installing.

Look inside the ZIP archive for the folder that corresponds to the Domibus version you are installing. Inside the folder you will find the script for a clean installation of the database schema of your choice (MySQL or Oracle) along with some utility scripts.

For further detailed instructions on how to do a clean install of Domibus, please check the instructions from the target Domibus release page (here for the latest one or browse for the specific release page for older ones).

Note: the ZIP archive only contains installation scripts for the supported versions of Domibus. In case you want to install a version that is no longer supported, please contact the eDelivery support team.

4.2. When upgrading an existing instance of Domibus

Always download the latest version of the scripts irrespective of the version of Domibus you are upgrading from/to.

Upgrading Domibus is an incremental process that is achieved by upgrading one step at time from one version to the next. Several upgrade steps may be needed depending on the initial and target Domibus versions.

Look inside the ZIP archive and locate the folder called "upgrade". Inside the folder you will find upgrade scripts from/to various Domibus versions organised by database product (MySQL or Oracle).

For instructions on how to upgrade to a specific Domibus version please check the instructions for each intermediate Domibus release between your initial and target versions (here for the latest one or browse for the specific release page for older ones).

Note: the ZIP archive contains installation scripts that enable upgrade to a supported versions of Domibus. In case your current version old enough that also the next version of Domibus is out of support, you will not find all the necessary scripts for the upgrade inside the archive. In this situation please contact the eDelivery support team.

5. Contact

For more information, please contact us via our portal or by e-mail: EC-EDELIVERY-SUPPORT@ec.europa.eu.