Migration Tool

The WhereScape Migration tool allows you to migrate metadata repositories from WhereScape RED Classic to WhereScape RED 10+. The following sections provide information on how to install and use the WhereScape Migration tool. 

Prerequisites For PostgreSQL Metadata

Before you begin the following prerequisites must be met:

• Create Database and ODBC DSN:
  • Supported* version of PostgreSQL (PostgreSQL 12 or higher)
    • A database to house the RED Metadata Repository.
    • A database for the Range Table DB (Optional)
    • A database to house scheduler (Optional)
    • Software Installations
  • WhereScape RED10 with valid license key entered and EULA accepted
  • WhereScape Enablement Pack for target database version RED10
• Windows Powershell (64-bit) version 4 or higher
  • To check the Windows Powershell Version:
    • Run the below command in Windows Powershell
      

      Get-Host|Select-Object Version

• • • Run the below command in the Command Prompt
      

      powershell $psversiontable

• Run the following command using PowerShell
  • • The security protocol TLS 1.0 and 1.1 used by PowerShell to communicate with the PowerShell gallery has been deprecated and TLS 1.2 has been made mandatory
      

      [Net.ServicePointManager]::SecurityProtocol = [Net.ServicePointManager]::SecurityProtocol -bor [Net.SecurityProtocolType]::Tls12
      Register-PSRepository -Default -Verbose
      Set-PSRepository -Name "PSGallery" -InstallationPolicy Trusted

• • • Progress bar placeholder info line
      

      Install-Module -Name PoshProgressBar -SkipPublisherCheck -Force

• RED supports the following versions for the metadata repository: PostgreSQL 12 or higher

Installing the Migration Tool

1. Launch the Install Wizard as administrator.
2. Select Create a new repository.
3. Configure the metadata repository.
   
4. Select the directory that contains the unzipped migration tool. Click Next.
   
5. Select the components that you want to install. Click Next.
   
   

Create Target Connections

You must create two PostgreSQL connections with the following characteristics:

Adding the Target Connection

The connection named 'Target' will be your PostgreSQL connection to your database to house the migrated RED metadata repository. 

1. On the Connection Name field, ensure to enter 'Target' as a name. On the Target Storage Locations field, ensure to enter 'red'.
2. Complete the other fields with the appropriate data, then click Validate to check your configurations.
   
   
3. Once you validate your configurations click Add.  
4. On the Add Targets screen you will see the connection you just added. Click Add another target to add the Reports connection.
   

Adding the Reports Connection

The connection named 'Reports' will be your PostgreSQL connection to your Migration Tooling metadata repository, which allows us to add targets to the tooling metadata database for reporting.

1. On the Connection Name field, ensure to enter 'Reports' as a name. On the Target Storage Locations field, ensure to enter 'red'.
2. Complete the other fields with the appropriate data, then click Validate to check your configurations.
   
   
3. Once you validate your configurations click Add.  
4. On the Add Targets screen you will see the two connections you just added. Click Next continue and add the source connection.
   

Adding the Source Connection

1. On the Add ODBC Sources screen, configure the data source you want to migrate from RED Classic. Click Validate to check your configurations and then click Add.
   
   
2.  The Add ODBC Sources screen will show the connection you just added. Click Next to continue or click Add another source to add more sources.
3. On the Summary screen review your configurations are correct, you can click Previous to make changes or click Install to continue.