Rehosting DevTest Databases to SQL Server 2022

Products

• Service Virtualization

Issue/Introduction

We would like to upgrade our SQL Server Database host to  a new Windows Server 2022, running SQL Server 2022 

1. What are the steps to do this?

2. Do we need to upgrade the driver as well or what driver do we need?

3. Are there any configurations that we need to change?

4. Can the backup be restored directly to the new DB or there steps that need to be done first?

Environment

All supported DevTest releases.

Resolution

The basic steps are as follows (as long as the accounts and passwords used to access the DBs don't change):

1. Work with your Network Security team to ensure the communication ports are open between the DevTest servers, and the new SQL Server host(s).
   
   
2. Stop the DevTest Services
   
   
3. Have the DBA back up the databases on the old host
   
   
4. Restore the Database on the SQL Server 2022. Assuming there's nothing needed on the SQL Server side, but your DBA should know what is required.
   
   
5. If the hostname changes, the properties file will need to be updated to point to the new host.
   
   
   • Identity Access Manager: C:\Program Files\CA\DevTest\IdentityAccessManager\iam.properties
   • Enterprise Dashboard: C:\Program Files\CA\DevTest\dradis.properties
   • Registry: C:\Program Files\CA\DevTest\site.properties
     
     Note: If the account name, or password has changed for the account used by DevTest to access the databases, then you will also need to update the account information in the properties files as well.
     
     
6. Restart the DevTest Services

Additional Information

The official database requirements can be found in section "Database Requirements" of the DevTest documentation for the version you are running.