How to move from SQL Server 2005 to SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014

Effective July 14, 2015, Blackbaud no longer supports  SQL Server 2005.  End of support means we will no longer test software releases on or address product issues with Microsoft SQL Server 2005.

As such, our recommendation is that you upgrade or migrate from SQL Server 2005 to a later version of SQL Server supported with your Blackbaud product or consider moving your database to Blackbaud's Hosting platform.
Blackbaud ended support for SQL Server 2005 effective July 14, 2015.   Please review and completed the following recommended options if you are using SQL Server 2005:

Please follow the instructions below specific to the version of SQL Server you are upgrading to or installing:

SQL Server 2008 R2 Express:

  1. Verify you don't exceed the database size limitation of SQL Server 2008 R2 Express
  2. Verify your application is compatible with SQL Server 2008 R2
  3. Backup your database(s)
  4. Detach your database(s) from SQL Server 2005 using the Blackbaud Management Console
    Note:  Prior to detaching your database(s), note the primary file path of the database(s) to use when re-attaching your database(s)
  5. Install or upgrade to SQL Server 2008 R2 Express
  6. Attach your database(s) to the newly installed SQL Server instance using the Blackbaud Management Console, browsing out to the database file location noted in step 4 above.


SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014:

  1. Verify your application is compatible with SQL Server 2008, SQL Server 2008 R2 ,SQL Server 2012, SQL Server 2014
  2. Backup your database(s)
  3. Detach your database(s) from SQL Server 2005 using the Blackbaud Management Console
    Note:  Prior to detaching your database(s), note the primary file path of the database(s) to use when re-attaching your database(s)
  4. Install and/or review the Microsoft steps to upgrade SQL Server to SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014
  5. Prepare SQL Server 2008 / 2008R2 / 2012 / 2014 for use with Blackbaud databases
  6. Attach your database(s) to the newly installed SQL Server instance using the Blackbaud Management Console, browsing out to the database file location noted in step 4 above.

Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing resolutions from these websites.

If your organization would find it more beneficial to move to our hosting platform, please contact your account executive for more information.  With Blackbaud Hosting Services, your organization will realize the time and cost savings associated with servers, hardware, security tools, software installation, and system upgrades. We leverage the best available technologies to improve overall performance and to maintain your data, while allowing 24/7 access to your organization's information.

Environment

 SQL Server 2008;SQL Server 2008 R2;SQL Server 2012;SQL Server 2014

Was this article helpful?