• Automatic Database Migration Process

  • Help us to improve OpenKM! Be part of the Open Source Community.
Help us to improve OpenKM! Be part of the Open Source Community.
Forum rules: Please, before asking something see the documentation wiki or use the forum search function.
 #46169  by Phoenix880
 
Hi!

To upgrade OpenKM, it is currently necessary to run manual SQL and "Java Code" scripts. To run Open KM with Docker in a fully automated cloud environment, I need an automatic migration.

Are there plans to introduce a migration engine like Liquibase or Flyway into OpenKM?
 #46181  by jllort
 
Professional edition comes with tool what automatically does it, but community edition still does not have.

If Liquidbase and Flyway are relational databases supported by hibernate 3.x, then should be working now for community version. Professional version works with upper hibernate version 5.x ( that's because community is the 3-4 years ago professional version released as community, this is the way of how we release the software to the community ).
 #46182  by Phoenix880
 
Where can I find further information about the migration tool in professional edition ? Which steps are reqired to migrate the database in professional edition?

Liquibase and Flyway are not relational databases but migration engines (frameworks) for databases.
 #46184  by jllort
 
If are not realtional databases then I think will not working with OpenKM now.
 #46224  by Phoenix880
 
Where can I find further information about the migration tool in professional edition ? Which steps are reqired to migrate the database in professional edition?

Automatic migration is an important feature for us, and a reason to switch to professional edition.
 #46227  by pavila
 
In OpenKM Professional there is a tool which do the required steps to update a given OpenKM instance to a newer version. This implies SQL statements, HQL statements and BeanShell code which perform the required tasks. You just download the tool, execute it and it will download automatically the newer OpenKM release and will perform these tasks. These are the detailed steps:
  • Check if it's located at $TOMCAT_HOME folder, otherwise will raise an error message.
  • Ask for some information to the administrator.
  • Check the service configuration, the user connection and the OpenKM version.
  • If the utility is successful on these checks, it will require confirmation by the user to proceed with upgrade [y/N].
  • Download the new OpenKM.war file ( current version + 1).
  • When finished downloading, it will execute pre-upgrade actions.
  • Stop OpenKM.
  • Replace the old OpenKM.war file by the new downloaded one.
  • Modify the parameter hibernate.hbm2ddl to update into the file $TOMCAT_HOME/OpenKM.cfg.
  • Start OpenKM again.
  • Check if OpenKM is already available and then execute post-upgrade actions.
 #46261  by Phoenix880
 
We run OpenKM in a Docker Container with the official OpenKM Image:
https://hub.docker.com/r/openkm/openkm/

1. Is there a Docker Image for Professional Edition too ?

2. When using Docker, you do not need to download a war file but only update the Docker image.
How does the OpenKM Migrations Tool work together with Docker ?

3. Is it possible to run the migration tool without user interactions ?

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.