How to Migrate Users from JasperReports Server 7.5.1 to 7.9 Without Exporting/Importing Process

User Requirement

Due to the security policy and user information process restrictions by the DBA, our users are not "allowed to have user profile information in the jiuser table stored in any other media for any reason". This restriction could make it impossible to migrate user profiles using export/import utilities for the JasperReports^® Server 7.5.1 to 7.9 upgrade.

The Suggested Approach

In JasperReports Server upgrade guide, there's a process to use js-upgrade-samedb shell script to upgrade two adjacent versions of the product. This upgrade keeps the existing repository content as is but simply updates the DB schema to reflect any changes for tables, columns, indice, and reference keys.

The process consists of two parts: update the DB schema, and deploy the new JasperReports Server web application. Users can use a similar approach to upgrade their JasperReports Server from 7.5.1 to 7.9 as the following:

• If the profile database is managed by their DBA, users can ask him/her to run the following SQL scripts under buildomaticinstall_resourcessql{repo database} folder in the installation package:

  postgres=#\i upgrade-postgresql-7.5.0-7.8.0-pro.sql
  

• If users' DBA has granted access to the repo database to application users, then the users can configure default_master.properties file and run the following ANT script:

  cd \Jaspersoft\jasperreports-server-7.9.0\buildomatic
  js-ant upgrade-7.5-7.8-pro    
  

This will take care of the repo DB part of the upgrade from JasperReports Server 7.5 to 7.9.

Note: There are no schema changes between 7.8 and 7.9 version of JasperReports Server repository therefore users do not need to run DB script for 7.8-7.9 upgrade. The JasperReports Server 7.9 js-upgrade-samedb script just carries out theme update and web application deployment which will be covered in the following steps.

• The application users can update repo with JasperReports Server 7.9.0 default theme by either run 

  js-ant import-minimal-for-upgrade-pro
  

  or

  import the corresponding 7.9 default theme provided by Jaspersoft Tech Support.

• The application users can deploy JasperReports Server 7.9.0 using the installation script:

  js-ant deploy-webapp-pro
  

TTC-20211130-2050825