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

Document ID : KB000016432
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Can I keep my existing database schemas of 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?

Answer:

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 from DevTest 8.x or 9.x, the schema of 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:

Here are some useful links on upgrading your database: 
https://communities.ca.com/docs/DOC-231171434-devtest-solutions-95-upgrade-center 
https://docops.ca.com/devtest-solutions/10-1/en/installing/upgrading-devtest