Migrating DevTest Database from one database to another

Products

• Service Virtualization

Issue/Introduction

This article explains steps to take to migrate a DevTest database:

From one machine to another or from one database format to another (example would be from Oracle to SQL Server)

Environment

All supported DevTest releases and platforms.

Cause

 

Resolution

DB Servers can be migrated via native DB Backup and Restore processes, but Broadcom does not provide a tool for migrating between DB formats like Oracle to SQL Server.

For any database migration, follow the below steps:

• It is the responsibility of the DBA to create the new databases for IAM, Enterprise Dashboard and Registry on the Database server machine and exporting the data from the old database and importing to the new database.
• Stop all DevTest components.
•  Update the below property files for the following components to point to the new database:
•  IAM:  DEVTEST_HOME/IdentityAccessManager/iam.properties
•  Enterprise Dashboard: DEVTEST_HOME/dradis.properties
•  Registry: DEVTEST_HOME/site.properties

NOTE: Make sure no DevTest server components are running on any machines including Workstations and no Java processes are running related to DevTest after stopping the components and before starting.

• Start all DevTest server components and Workstations.
• Verify the the databases are populated with tables.
• Stop the DevTest components again and do the data migration.
• Restart all the DevTest components.

Additional Information

Refer to "System Requirements" section in the Documentation of the version of DevTest you are running. Especially sections "Operating System Requirements" and "Database Requirements"

NOTE:  DB2 not supported for IAM.