Step 1 - Get the upgrade DB Script
Use the bellow location for the “PSKnowhow” DB script:
https://github.com/PublicisSapient/PSknowHOW/tree/master/database-scripts/upgrade-scripts
In this repository, you will find multiple JavaScript files, each corresponding to a specific database upgrade version.
Identify the version you are currently using, and note it down. For instance, if you are currently using version 7.x, you should look for the script with the filename
Release-8.0-from-7.0.js
.If you have upgraded your software to version 8.x, you should instead run the script with the filename
Release-9.0-from-8.0.js
.Execute the appropriate JavaScript file using your preferred method of running scripts in your database environment you can refer this docs
The script will handle all necessary schema modifications and updates to make your database compatible with the latest version of our Knowhow.
After the script has been successfully executed, we recommend restarting the customapi
Code Block docker restart customapi
After restart of service verif the integrity of your database and performing any necessary tests to ensure everything is functioning as expected.