CA Service Management

  • 1.  SQL version support

    Posted Jul 10, 2017 05:22 AM

    Hello Team

     

    Please I want to know if sdm 12.6 support sql 2014 or not?

     

    We are currently in the phase of migration to sdm 17. We are first migrating sdm 12.6 database to sql 2014 (if it supports) then we will migrate application to 17 version

     

    Please advise



  • 2.  Re: SQL version support
    Best Answer

    Posted Jul 10, 2017 06:23 AM

    Hi Aamir,

     

    SDM r12.6 is NOT certified with SQL2014.

     

    If you need to upgrade, then follow the steps documented in the link below:

     

    Migrate or Upgrade to CA SDM 17.0 - CA Service Management - 17.0 - CA Technologies Documentation 

     

    Kind Regards,

    Brian



  • 3.  Re: SQL version support

    Posted Jul 10, 2017 06:48 AM

    Hi Brian

     

    Tha ks for the reply

     

    Is 12.6 certified with Ms sql 2012?

     

    On 10-Jul-2017 3:23 pm, "Brian_Mathato" <



  • 4.  Re: SQL version support

    Posted Jul 10, 2017 08:07 AM

    HI Aamir,

    Yes, it is as shown in the cert matrix here: https://support.ca.com/phpdocs/0/8165/8165_r126_CertMatrix.pdf 

     

    Certified Databases All Databases are certified for both 32-bit and 64-bit unless specifically noted.  Microsoft SQL Server 2012 o Note: Requires SDM Patch “RO51630”  Microsoft SQL Server 2008 R2  Microsoft SQL Server 2008 SP1  Microsoft SQL Server 2005 SP2, SP3  Oracle 11g R2  Oracle 11g  Oracle 10g R2

     

    Again however, since 12.6 has went end of support several years back, we highly recommend that you upgrade to a supported version of the product as soon as possible so that we can further assist you on any issue you may encounter.

     

    You can find the product lifecycle dates here: CA Service Desk Family Release and Support Lifecycle dates - CA Technologies 

     

    Thanks,

    Jon I.



  • 5.  Re: SQL version support

    Posted Feb 16, 2018 11:49 AM

    Hi,

     

    I know it may be a little bit out of scope from the original question as my question concerns more CA SDM 14.1.04.1 to 17.0. I'd like to know if SQL 2008 is supported with SDM 17?


    On the supportability matrix page it only shows details for SQL 2012 and up.

     

    Thank you and have a good day



  • 6.  Re: SQL version support

    Broadcom Employee
    Posted Feb 16, 2018 12:05 PM

    Benoit.........

     

    As indicated in our 17.0 documentation (Supportability Matrix - CA Service Management - 17.0 - CA Technologies Documentation ) SQL 2008 is NOT supported/certified.

     

    In addition, Microsoft ceased mainstream support for SQL 2008 in 2014 and Microsoft Extended Support for SQL 2008 will end in July 2019.



  • 7.  Re: SQL version support

    Posted Feb 16, 2018 01:44 PM

    Hi Paul, thanks for the confirmation. On the supportability matrix page it was not intentionnaly specified. I know that the end of support is coming soon for sql 2k8 but I'm not managing the database. I will address the issue to my colleagues that manage the DB to let them know that I need 2012 and up in order to implement SDM17.

    Thanks,



  • 8.  Re: SQL version support

    Posted Feb 16, 2018 01:11 PM

    No 2008sql not supported with SDM 17

     

    On 16-Feb-2018 9:49 pm, "blav" <communityadmin@communities-mail.ca.com>