Upgrade to SQL Server 2014

Table of Contents


Summary

This article will take you through the process of upgrading an older version of SQL Server to SQL Server 2014. You MUST be logged in as the Administrator before continuing.

If you are running a network database you will want to upgrade both the Master computer, where data is stored, and the Client computers, that pull data off of the Master computer. This will make sure that all the computers connecting to the network database are all running the same version of SQL Server.

If you don't have a version of SQL Server already installed, you will instead want to read the support article on Installing SQL Server 2014.


Upgrade Your SQL Server

This portion of the article will guide you through how to upgrade your SQL Server to SQL Server 2014. Click through the tabs for written instructions, in the last tab you will tutorial videos to take you through the written steps.

Backup SQL Raw Data

Before you perform the upgrade MyoVision's Technical Support Team recommends backing up your raw database file in case there is an issue during the upgrade process.

Navigate to C:\ProgramFiles(x86)\Microsoft SQL Server\MSSQL10.5.SQLEXPRESS\MSSQL\DATA in Windows File Explorer.
Hold down the control key on the keyboard and click on the myovision and myovision_log files. Then right-click and select copy.

At this point you will want to create a location on the Desktop or in your MyDocuments to paste the copies to. Then, navigate to that folder, right-click, and choose Paste.

The copies will be used if the MyoVision database gets corrupted during the upgrade process, to rebuild your MyoVision database.

Upgrade SQL Server

Once you are logged in as an administrator you are ready to begin upgrading from SQL Server 2014

  1. With file explorer navigate to C:\WinScan98\SSE2014. Right-click the SETUP.EXE file and select Run as administrator.

  2. When the SQL Server Installation Center loads select the "Upgrade from..." option.

  3. You will need to accept the license terms and conditions, then you can click Next to begin the upgrade.

  4. On the next screen choose which instance of SQL Server you want to upgrade from the drop-down menu.

  5. At this point the SQL Server Installation Center will perform the upgrade.

  6. When you reach the Complete screen you can click the Close button to finish the upgrade.


Troubleshooting

If you are experiencing an SQL Error after upgrading your SQL server you will want to follow the steps in the guide below.

Re-Attach Database File

The first step will be to try and re-attach the Database file to the software.

  1. Open the Setup menu and select Database
  2. Click the Advanced button to see the Advanced options.
  3. Click the Attach button and when the pop-up comes up click Yes
  4. Select the MyoVision file and click Open.
  5. If the attach is successful the following message should display.
    Attempt to Open an Exam or perform a new one to see if the issue is resolved.

Restart Service

The next troubleshooting step is to restart the SQL server instance. 

  1. Open the Setup menu and select Database.
  2. When the Database Setup window opens click the Local Services button. (If the Local Services button is not there you will need to Update Your MyoVision Software.)When the pop-up appears click Yes.

  3. Locate the SQL Server service in the list, right-click and select Restart.
    If the Restart option is not available select Start instead.Try opening an exam or  performing a new one to see if the SQL Server error has been fixed.