How to Perform a Database Migration for GDOT Unified
Download as pdf :
Products:
Aspen GDOT
Last Updated:
13-Dec-2022
Last Updated:
13-Dec-2022
Versions:
Article ID:
000100547
Article ID:
000100547
Primary Subject:
Attachments (1)
Attachments (1)
Problem Statement
This article described the steps to perform the migration database for Aspen GDOT Unified. This process is normally required after the installation of some patches.
Solution
The Migration process is done using the same application required for the installation and setup the SQL Databases when Unified is Installed. The application is called PscAdmin.exe and can be found on:
C:\Program Files\AspenTech\Aspen Unified\Admin\binX64
To open the application, Run a CMD as Administrator then use the command:
cd C:\Program Files\AspenTech\Aspen Unified\Admin\binX64
to go into that folder and then Type PscAdmin to check the different options that the application has
One of this option allows to migrate the input database, which what commonly we need to do when we have warnings or error in GDOT Unified pointing to Database Migration.
This normally the type of error you can find
Input Databases Pending Migration
GDOTV121\InputV12.1
To complete the migration process the syntaxis will be:
>pscadmin migrate-input-db –databaseServer NAME_OF_SERVER –databaseName DATABASE_NAME
In the following example the name of the Server is EVA00\SQLEXPRESS and the Database Name is AUInput
The same process can be applied with the rest of the Databases. For a typical GDOT Unified installation there are 4 Databases:
-Input (Normally called AUInput)
-Master (Normally called AUMaster)
-Results (Normally called AUResults)
-SiteCatalog (Normally called AUSiteCatalog)
All of them may need to be migrated using the same command syntaxis.
As an additional and optional, Note there is include a shot .bat file that can help with the migration process. The .bat file need to be run as administrator and you will only have to specify the name of the Server and the Database
Note that this will only works as GDOT is installed on C Drive on the Server.
Keywords
GDOT Unified, SQL, Database
Attachments
Filename
Date Added
Unified_Migration.bat
12-Dec-2022