ALM Database upgrade (SQL2008 to SQL2012)
We are using ALM 12.01 patch 2 , SQL server 2008
DB team wants to migrate to Microsoft SQL Server 2012 SP2 on same sever.
I have ensured all entities are checked-in and DB has been backed up before DB upgrade.
Kindly let me know any other action items from my side as ALM admin, kindly share the steps.
Re: ALM Database upgrade (SQL2008 to SQL2012)
Every release of ALM is accompanied by a database upgrade. In most cases,
both of the ALM database user schemas require modifications. For this
reason, both are upgraded by the database upgrade.
Follow ALM Guidelines
When upgrading the ALM database schema, follow these guidelines:
• Use Project Verification
The ALM project upgrade mechanism includes a robust module that
enables you to check the compatibility of your current ALM database
deployment with the ALM database schema methodology and the next
database upgrade. It is recommended that you use this verification
capability. Fix all incompatibilities found before actually upgrading an
ALM project database user schema. Run this utility on a regular basis, at
least once a month, and fix the issues it finds. Doing so helps you reduce
the amount of work needed when preparing for the actual upgrade.
• Back Up User Schemas
Before performing any upgrade activity, back up all of your ALM
database user schemas.
• Upgrade the Site Administrator Database Schema
If the installation wizard detects a previous version of ALM during the
installation process, it gives you the option to Copy or Upgrade the
existing database. You should use this option to ensure that you can
continue working with old projects with the old site admin schema. For
details, see the HP Application Lifecycle Management Installation and
For more information about planning your upgrade, see HP Application
Lifecycle Management Upgrade Best Practices.