Steps for manually upgrading Blueprint Analyst databases from 4.1 to 4.2 ============================================================================
The following instructions explain how to manually upgrade the Blueprint Analyst databases.

 

A manual upgrade of the Blueprint Analyst databases will be required if the original install was to a remote database, with the databases hosted on SQL Server running on a separate machine from the other Blueprint components. The remote database will typically have been installed manually when Blueprint was originally installed.

 

These instructions apply to the manual upgrade of the Blueprint Analyst databases from 4.1 to 4.2

All the files required to carry out a manual upgrade of the databases are available in the 4.2 under ".\Program Files\PharosSystems\Blueprint\Database\MSSQL"

 

Preparation
-----------
1. In the Services Control Manager, stop the Pharos Systems TaskMaster and Pharos Systems TaskMaster Watchdog services.
2. Close all copies of the Blueprint Administrator connected to the Blueprint Analyst databases.
3. Backup the Blueprint Analyst databases, by executing the "Pharos Blueprint Database Backup" SQL Server Agent job through SQL Server Management Studio. Copy the resulting backup files to a secure location.

 

Database Upgrade
----------------
1. Upgrade the partition databases psjobs[1..N]
This step updates the schema in each of the psjobs databases and can be carried out using the Blueprint SQL logon account, the "sa" or a Windows Administrator account.

 

Using SQL Management Studio open and execute contents of the file .\Analyst\UpgradePartitionHead.sql against the psjobs1 database.

 

Depending on the volume of data in the database this script may take a few minutes to run.

 

Using SQL Management Studio open and execute contents of the file .\Analyst\ UpgradePartition5586.sql against the psjobs1 database.

 

Using SQL Management Studio open and execute contents of the file .\Analyst\UpgradePartitionTail.sql against the psjobs1 database.

 

Repeat the above steps for each of the partition databases psjobs[1..N].

 


2. Upgrade the main psbprint database
This step updates the schema in the main psbprint database and can be carried out using the Blueprint SQL logon account, the "sa" or a Windows Administrator account.

 

Using SQL Management Studio open and execute contents of the file .\Analyst\UpgradeAnalystHead.sql against the psbprint database.

 

Using SQL Management Studio open and execute contents of the file .\Analyst\UpgradeAnalyst5586.sql against the psbprint database.

 

Depending on the volume of data in the database this script may take a few minutes to run.

 

Using SQL Management Studio open and execute contents of the file .\Analyst\UpgradeAnalystTail.sql against the psbprint database.
This completes the manual upgrade of the database.

 


The Blueprint Analyst components can now be upgraded using the 4.2 Installers.
The Pharos Systems TaskMaster service will not restart cleanly until it has been upgraded.

 

To check if the database has been upgraded successfully run the following query:
select * from databaseversion against psbprint it should return 5586 as the BuildNumber.