Frequent Contributor.. Vignesh Palanivel Frequent Contributor..
Frequent Contributor..

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. 




Labels (1)
Tags (2)
1 Reply
MarioMiranda Respected Contributor.
Respected Contributor.

Re: ALM Database upgrade (SQL2008 to SQL2012)


Database Upgrade:

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
Upgrade Guide.
For more information about planning your upgrade, see HP Application
Lifecycle Management Upgrade Best Practices.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.