Perform a test upgrade of the BlackBerry UEM database
This task should be performed by a database administrator with the appropriate permissions to back up, restore, and upgrade the BlackBerry UEM database. If you do not want to run CreateDB on the database server, you must run it on a computer where UEM is installed. The computer must be able to connect to the computer that hosts the database server that you want to perform a test upgrade of the UEM database on.
Verify that you configured the correct permissions on the database server that you want to perform a test upgrade of the UEM database on.
Log in to the computer that hosts the database server for the UEM database.
Back up the UEM database.
Log in to a computer that hosts a database server that you want to perform a test upgrade of the UEM database on.
Restore the backup version of the UEM database.
Copy the UEM installation files to the computer.
Do not copy used installation files from another computer. You must re-extract the installation files on each computer.
Extract the contents to a folder on the computer.
Navigate to <extracted_folder>\db.
Open the CreateDB.properties file in a text editor.
Change the file to include information that is specific to your organization's environment.
For more information on the contents of the createDB. properties file, see CreateDB.properties file .
Save and close the file.
Open a command prompt window.
Change the directory to <extracted_folder>\db.
Type CreateDB.bat upgrade CreateDB.properties and press ENTER.