The instructions below show how to upgrade the version or edition of Microsoft SQL Server. For example, follow the instructions to upgrade from:
- SQL Server 2008 R2 Express to SQL Server 2016 Express (upgrading the version)
- SQL Server 2016 Express to SQL Server 2017 Standard (upgrading the edition)
This Microsoft knowledge base article on upgrading to SQL Server 2017 can provide more information on upgrade compatibility.
Upgrading from the Express edition to a Standard or Enterprise edition is necessary if your database is approaching the 10 Gb size limit for the Express edition.
These instructions can be used if you are running the following Bp Premier versions:
Indigo Revision 1
The example below shows upgrading to SQL Server 2017. The screens on your server may appear slightly different, depending on your version of Windows, but the upgrade process is the same.
Before you begin
You will need the installation media for the version or edition of SQL Server you are upgrading to. This might be in the form of a DVD, or an executable installer that you have downloaded and unpacked from a Microsoft SQL Server internet resource.
Back up your existing database immediately prior to the upgrade.
Upgrade SQL Server version or edition
- If your SQL Server install media is on a DVD, insert the DVD into the Bp Premier server.
- In a Windows File Explorer, navigate to the DVD or the folder containing the install files. Double-click the file Setup.exe.
- The SQL Server Installation Wizard will open. Click the option Upgrade from a previous version of SQL Server.
- Tick Accept the license terms and click Next.
- Tick Use Microsoft Update to check for updates (recommended) if your practice wishes to check for updates to SQL Server automatically. Ticking or not ticking this option will not affect installation. Your practice's IT policies will determine if you should tick this option. Click Next
- Select the SQL Server instance you want to upgrade and click Next.
- The installation wizard will begin running rule checks. If you are upgrading to SQL Server 2012 or higher, the following message will appear twice during the upgrade: 'Login failed for user *\BpAdmin. Reason: The account is disabled.' Click Cancel to proceed with the installation every time this message appears.
- The following screen will appear when SQL Server upgrade is complete.
IMPORTANT This message is generated because of changes to database access in recent versions of Bp Premier, and is the only message that you can safely click Cancel on to proceed with the upgrade. If you receive any other error messages, you will have to handle those error messages case by case.