Is a new database schema required for IAM, EDB and Registry while upgrading DevTest?

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

Can I keep my existing database schemas of IAM, EDB and Registry while upgrading to higher version of DevTest?

Or do I need to create new database schema and do a manual migration of the data in these schemas?

Environment

All supported DevTest releases.

Cause

N/A

Resolution

You can keep the same database schemas as earlier version instead of building a whole new one as long as you are planning to use the same DB (i.e. as an example, Oracle to Oracle but not Oracle to SQL Server).

You would be able to upgrade the schema, provided the user has the DBA privileges. This is called an in-place upgrade (Useful links are provided below). However, it’s always safe if you can take a backup of the DB before upgrading. 

When you do an in-place upgrade, the schema of IAM, the Enterprise Dashboard and the Registry database is updated and the existing data is maintained. You do not need to create a new database. 

Additional Information

Refer to section "Upgrading DevTest" in the documentation of the DevTest release you are running.