search cancel

Migrating an existing GTREP Repository Database and TDM Portal Installation to a new server.

book

Article ID: 223564

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have a new server with Windows 2016 Server. We need instructions for moving our production TDM 4.8.1 installation over to our new server. We need to have the two servers running in parallel, for validation, before replacing the old server with the new server. It's important we migrate our existing GTREP database data, as well as OrientDB data, to the new server for our validation testing.

 

Environment

Release : 4.8+

Component : TDM Web Portal

Resolution

 

The recommendation is to do the following:

  1. Have your DBA take a new backup of the existing GTREP database to a file

  2. Have your DBA create a schema and user account on the new database server, that can be used for your new GTREP Database instance.
    For simplicity’s sake and documentation purposes, we will call this GTREP_NEW, but it can be the same schema name used on the old database server.

  3. Have the DBA restore the GTREP backup file to the new schema, GTREP_NEW
    Note: If the GTREP database is not changing, the first three steps can be skipped. However, best practice recommends having the DBA take a backup of the GTREP database, since it's very important to keep the GTREP data and OrientDB data in sync.

  4. At the same time, stop the OrientDB service on your old Portal server, and make a backup of the %ProgramData%\CA\CA Test Data Manager\
    • objects
    • orientdb

  5. Install TDM Portal on your new server. The installation will ask for the repository connection information. Provide the necessary information to connect to the GREP_NEW schema.

    Note: Do not have the installation media start the CA Test Data Manager Portal service, by unchecking the Start TDM Portal checkbox

  6. Launch the Windows Services, and stop the OrientDB service

  7. Copy the backed up OrientDB folders (objects and orientdb) from the old %ProgramData%\CA\CA Test Data Manager Portal to the new server

  8. Restart the OrientDB service and CA Test Data Manager Portal services

  9. Login into Portal and verify the Self_service tiles are present.

NOTE: Be mindful of the limitations Windows Server OS has on hostname restrictions.

https://docs.microsoft.com/en-us/troubleshoot/windows-server/identity/naming-conventions-for-computer-domain-site-ou

NOTE: If making changes to the hostname of the machine where TDM Portal is installed, you will need to modify the %ProgramFiles%\CA\CA Test Data Manager Portal\conf\application.properties file, and restart the CA Test Data Manager Portal service. Also, check the system environment variables for the TDM_PORTAL_URL variable, this will also need to use the new hostname. If you are using TDoD, you will also need to modify the C:Grid-Tools\TDoD\TDOD_WebUI\Web.config file.