New article
Recently updated
Upgrading the Please Review 8 Database
Who is this article for?
IT Personnel planning an upgrade to Please Review 8.
IT access is required.
Important: This article is part of a series of articles covering the upgrade process. Please visit Performing a Please Review 8 Upgrade to view the entire process.
As part of the Please Review upgrade it is essential that the database is also upgraded to match the application.
This article outlines the steps required to perform the database upgrade. The steps you need to follow will vary based on the database platform you have chosen to host your Please Review database and so this article is split into the following sections:
1. Microsoft SQL Server
- Backup the database.
- Open the installation media.
- Navigate to runtime\config\migration.
- Open the SQL script for the version immediately above your current one (e.g., if upgrading from v7.5, start with v7.6).
- Launch Microsoft SQL Management Studio and log in as the user specified in runtime\config\config.xml.
- Right-click the Please Review database and select New Query.
- Paste and execute the script.
- Repeat steps 3-7 for each subsequent version, running all migration scripts in chronological order (e.g., upgrading from 7.5 to 8.4 requires running scripts 7.6 through 8.4 sequentially).
If unsure or if errors occur, contact support before continuing. If urgent, consider restoring the backup from step 1 and reverting to the older version temporarily.
2. Oracle
- Backup the database
- Open the installation media.
- Browse to the runtime/config/migration directory.
- Open the Oracle script file relevant to the version immediately above the version of Please Review you are upgrading from. eg. if upgrading from v7.5, you would start with v7.6.
- Open a Microsoft Windows Command Prompt in the runtime/config/migration directory.
- Enter the following command:
sqlplus <user>/<password> <script>Example: sqlplus admin/abc@123 v7.1.oracle.txt
Note: The user used in the upgrade query must own the Please Review tables.
- Repeat steps 3-6 for each version in sequence:
When migrating the database, run all migration scripts from your current version up to the target version in chronological order. For example, upgrading from 7.5 to 8.4 requires running scripts for 7.6, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, and 8.4 in that order.
If unsure about the upgrade process or if errors occur, contact support before continuing. If urgent, consider restoring the backup made in step 1 or rolling back to the previous version temporarily.
What Next?
With the database upgraded you are now ready to begin testing. Please see Testing the Upgrade Was Successful for 8 for the next steps or Performing a Please Review 8 Upgrade to review the whole process.