Clarity

Expand all | Collapse all

Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

  • 1.  Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

    Posted 11-30-2016 10:52 PM

    Hi,

    We have CA PPM(Clarity) 13.3. The Database we are using is Standard edition of SQL server 2008 R2. We are planning to upgrade to 14.2, but in the release notes its mentioned SQL server 2008 R2 Enterprise Edition as supported version

     

    In the current infrastructure we don't have Enterprise edition. So have anyone upgraded to 14.2 version using the SQL server 2008 Standard/Developer edition ?

     

    Thanks and  Regards,

    Avinash



  • 2.  Re: Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

    Posted 12-06-2016 07:09 PM

    That should work, but it will not be supported. Any issues when contacting to CA support, if they suspect issue is due to DB version, they may request to upgrade version to resolve issue.

     

    You can always log a ticket for official statement from CA support.

     

    I'd personally go for supported version. You are taking risk and it will be more work when upgrade to higher releases.



  • 3.  Re: Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

    Posted 12-07-2016 10:31 AM

    Hi Avinash,

     

    We at CA Support do not recommend you to go with an unsupported database. In fact when you run your 14.2 upgrade the checkinstall part of the upgrade(the part that checks the requirements in the beginning) will fail on unsupported database version. Any way to get this to work will have to involve unsupported modification of the files. We would encourage you to get the Enterprise edition as this is the one we actually tested and certified with PPM.

     

    Hope this helps -Nika



  • 4.  Re: Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

    Posted 12-08-2016 02:28 AM

    Hi,

     

    In the Check-install report its not giving an error. Its giving a warning message.

     

    Database version check validated as appropriate for development or test environment only:
    Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) Mar 19 2015 12:32:14 Copyright (c)
    Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

     

    It didn't throw an error for unsupported database version.

    Thanks and Regards,

    Avinash



  • 5.  Re: Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

    Posted 12-08-2016 10:39 AM

    Hi Avinash

     

    The checkinstall should fail on any Standard edition, and would issue a warning for Developer edition, that is correct. I thought you were on Standard edition by your post description. It is still unfortunately unsupported to use.

     

    Thank you -Nika



  • 6.  Re: Upgrading CA PPM 14.2 on SQL server 2008 R2(Standard/Developer edition)

    Posted 12-07-2016 06:18 PM

    The developer edition of SQL Server is the same technical product as the Enterprise Edition.  Only the licensing is different.  You can't legally run that in production.

     

    -Josh