Upgrade to SQL 2019 and OS 2019

Gethin James
Gethin James
Sixth Anniversary Name Dropper Facilitator 1
in Blackbaud CRM Developer Discussions

Hi,

We're self hosted CRM and BBIS and planning to upgrade to both Windows Server 2019 and SQL Server 2019. Initial efforts in a dev environment are throwing up lots of issues (for example we think we'll have to rebuild all our SQL Server agent jobs as apparently ActiveX is depreceated from SQL 2019?). Has anyone successfully done this and would be able to share any pitfalls or lessons?

Many thanks,

Gethin

Comments

  • William Burke
    William Burke
    Third Anniversary Kudos 1 Name Dropper Participant

    @Gethin James Hi Gethin - I asked our product team about this and they replied that we have a knowledge base article that might be helpful: https://kb.blackbaud.com/knowledgebase/articles/Article/119837

    Note that this assumes you are upgrading from a version of SQL prior to SQL 2016, such as SQL 2014, and going straight to SQL 2019. If so, the steps covered in the above KB should apply.

    Thanks and good luck!

  • Stephen Liquorish
    Stephen Liquorish
    Fourth Anniversary Name Dropper Participant Facilitator 1

    @Gethin James After we converted the jobs we had httpRequest timeout issues when the job runs more than 1min, this KB covers it.

    We ended up setting up a scheduled SQL job to correct Business Process jobs as the KB suggests.

  • Gethin James
    Gethin James
    Sixth Anniversary Name Dropper Facilitator 1

    @William Burke
    Thanks that's helpful. Yes we're going from SQL 2014 but hadn't thought to search KB by “SQL 2016” just by SQL 2019!

  • Gethin James
    Gethin James
    Sixth Anniversary Name Dropper Facilitator 1

    @Stephen Liquorish, thanks so much! This is exactly the kind of thing I expect we'd have lost hours to and can now look for specifically. Cheers.

  • Chris Whisenhunt
    Chris Whisenhunt
    Fourth Anniversary Name Dropper Participant Facilitator 1

    @Gethin James Yes! We've done this now for many organizations that self host and helped with upgrades for clients that are hosted with Blackbaud. More than I can count. We're currently in the middle of a huge upgrade for multi-terabyte database with client that was one of the first on BBCRM!

Categories