Summary: Information about the Console V2 Migration Tool, a tool to migrate applications managed in Console V1 to Console V2 (Enterprise mode only).

Extension ID

com.castsoftware.aip.console.v2.migration

What's new?

See Console V2 Migration Tool - Release Notes - 1.0 for more information.

What is the Console V2 Migration Tool?

The Console V2 Migration Tool is a command line based tool (Console-V2-Migration.exe) that will migrate ALL applications managed in Console V1 into Console V2 (it is NOT possible to migrate only specific Applications). This migration includes:

Things to know

Prerequisites

Console V1

(tick)Console release≥ 1.27.0-funcrel
(tick)Node/AIP CoreAll Nodes MUST be running the SAME release of AIP Core.
(tick)Deployment/Delivery foldersAll Nodes must use "common" Deployment and Delivery folders (i.e. a shared network resource).
(tick)Stop all servicesAll Console V1 services (front-end and all Nodes) must be stopped before the migration is started.
(tick)Path to tool

The Console-V2-Migration.exe tool must be run from a path that does not contain white spaces, e.g.:

C:\CAST\Console-V2-Migration.exe

Console V2

(tick)Console release≥ 2.2.0-funcrel - Enterprise mode only (Docker or Java JAR installer -see AIP Console - front-end installation)
(tick)Node/AIP CoreAll Nodes MUST be running the SAME release of AIP Core as the Console V1 Nodes.
(tick)Deployment/Delivery foldersAll Nodes must use the SAME common Deployment and Delivery folders as used for Console V1.
(tick)CAST Storage Service/PostgreSQLAll CAST Storage Service/PostgreSQL instances configured in Console V1 must be configured in Console V2 (for both Analysis/Dashboard schema and Measurement schema requirements).). See Administration Center - Settings - CSS and Measurement settings.
(tick)Measurement schemaThe Measurement schema MUST use the SAME name as defined in Console V1. See Administration Center - Settings - CSS and Measurement settings.
(tick)Source folder location (optional)If you are uploading source code from a source folder location in Console V1, you MUST configure the SAME source folder location in Console V2.
(tick)CAST Imaging settings (optional)If you are publishing data to CAST Imaging, ensure you configure the SAME settings in Console V2 as in Console V1. See Administration Center - Settings - Imaging Settings.
(tick)Schema backup (optional)

Optionally, you may wish to perform a backup of the Console V2 internal schema called "aip_node" using PostgreSQL tools such as psql or PGAdmin:

Console-V2-Migration.exe syntax

Console-V2-Migration.exe

--h2dbfile           H2DBFILE      V1 - Path to H2 database without file extension (default: None)
--h2dbtype           H2DBTYPE      V1 - Node or Console (default: None)
--casthomedir        CASTHOMEDIR   V1 - AIP Core installation path (default: None)
--log                LOG           Output log file path (default: None)
--workingdir         WORKINGDIR    Backup processing path (default: None)
--schema             SCHEMA        V2 - "aip_node" schema name (default: None)
--user               USER          V2 - Username used to connect to target V2 CSS/PostgreSQL instance (default:operator)
--host               HOST          V2 - Host for Postgres server
--port               PORT          V2 - Port for Postgres server (default: 2285)
--database           DATABASE      V2 - Database name of CSS server (default: postgres)
--aipnodedir         AIPNODEDIR    V1 - Provide the path to the aip-node-app.properties (default: None)
--outputdir          OUTPUTDIR     Output path (default: None)
--zipfilename        ZIPFILENAME   Output Zip filename - .zip extension not required (default: None)
--v2path             V2PATH        V2 - Specify the path of the "common_data" shared folder (default: None)
--process            PROCESS       Specify the task (ALL or MIGRATION or CUSTOMSCRIPT or ZIP or MNGTSCRIPT) (default: ALL)

Note about paths:
- CAST highly recommends using backslashes where paths to folders/files must be specified.
- Quote marks (") around paths are not required, except where the path contains white space. However, using quote marks for all paths is also accepted by the tool.


The tool will prompt for the password of the user specified in the --user command (if this command is omitted, "operator" is assumed) and will accept only a plain text password. If you want to avoid the prompt, you can pass the following command in the command prompt before you run the Console-V2-Migration.exe tool, where <PASSWORD> is the plain text password for the user specified in the --user command:

SET CSSPASSWORD=<PASSWORD>

Migration process

The migration process contains distinct steps:

Step 1 - Run the tool on all Nodes

Run the Console-V2-Migration.exe tool on ALL Nodes, for example:

Console-V2-Migration.exe --h2dbfile "C:/ProgramData/CAST/AipConsole/AipNode/db/aip_node_db" --h2dbtype node --casthomedir "C:/Program Files/CAST/8.3" --log "C:/work/temp/mig/mig-node1.log" --workingdir "C:/work/temp/mig/workingdir" --schema aip_node --host v2_css_host --aipnodedir "C:/ProgramData/CAST/AipConsole/AipNode" --outputdir "C:/work/temp/mig/out" --zipfilename node1_backup --v2path "S:/common-data" 

When the tool completes, the following occurs:

Click to enlarge

Step 2 - Copy ZIP data from all Nodes to Console V2 environment

This step involves copying the content of all generated ZIP files over to the Console V2 environment into the "common_data" shared folder:

Step 3 - Perform the migration on the Console front-end host server

This step will migrate Console data such as domains, user rights (but not users or authentication settings), global settings, authorizations, global config files etc. from the Console V1 H2 flat file database over to the the Console V2 "aip_node" schema:

Microsoft Windows host

Run the Console-V2-Migration.exe tool on the front-end Console host server. For example:

Console-V2-Migration.exe --h2dbfile "C:/ProgramData/CAST/AipConsole/AipConsole/db/hellodb" --h2dbtype console --casthomedir "C:/Program Files/CAST/8.3" --log "C:/work/temp/mig/mig-console.log" --workingdir "C:/work/temp/mig/workingdir" --schema aip_node --host v2_css_host --v2path "S:/common-data"

Linux host

If your Console V1 is hosted on a Linux server, then the Console-V2-Migration.exe tool cannot be run on this host. Instead, the steps are slightly different:

Console-V2-Migration.exe --h2dbfile "C:/work/temp/mig/db/hellodb" --h2dbtype console --casthomedir "C:/Program Files/CAST/8.3" --log "C:/work/temp/mig/mig-console.log" --workingdir "C:/work/temp/mig/workingdir" --schema aip_node --host v2_css_host --v2path "S:/common-data"

Step 4 - Manually copy Architecture Studio data to Console V2 environment

The final step is to manually copy the content of the following folder (not the folder itself)

Microsoft Windows
C:\ProgramData\CAST\AipConsole\AipConsole\upload\architecture

Linux
$HOME\ProgramData\AipConsole\upload\architecture

to:

\\share\aip-node-data\common-data\upload\architecture

Step 5 - Verify process

The final step is to access Console V2 and perform the following verification checks:

At system level

At Application level

Take a sample selection of applications and check that the configuration of these applications is correct, for example:

  1. In the Application Overview panel, check that all the sections in this panel are as they were in Console V1
  2. In the Application - Extensions panel, check that the same extensions are defined as in Console V1
  3. In the Application - Config panel, check that you have the same technologies and the same configuration in the Analysis Units as in Console V1
  4. Etc..
  5. The module definition should be identical to Console V1
  6. The same for Architecture and the other options
  7. In the Application - Config - Advanced section, check that the DLM rules are correctly set (pointing to the DLM rules in the Console V2 common data folder)