Skip to main content
Find a Sales Rep

How Do I Upgrade My Aurora SQL Version?

Updated

Question

How do I upgrade my Aurora SQL version?

 

Answer

There are 2 methods of upgrading the SQL version of Aurora, and both require EAUR-UP

Items to consider before proceeding:

  1. If the installation uses Full SQL, contact Support to assist with the upgrade
  2. These instructions are for Aurora installations only, not Aurora with integrations
  3. Method 2 will break other SQL installations on the Aurora server; consider Method 1
  4. Instructions are for single-server installations. Large-scale installations should contact Support
  5. E-Plex, SDK/API, Web, AD Integration & remote connections need to be considered; contact Support
  6. Server specifications should be reviewed

 

Method 1 (recommended)

Set up a new server and transfer the database

The following KB articles can be used as a guides

Installing Keyscan Aurora Software

How Do I Move My Aurora Database To A New Server?

 

Method 2 (not recommended)

  1. To upgrade the SQL on the same server, back up your Aurora installation and copy the backup files to a safe location. If this is a server or VM, a SnapShot is also recommended
    If you have questions, contact Support before executing this type of upgrade
  2. Stop the Keyscan Aurora services via services.msc & close the Aurora Client
  3. Within the new Aurora ISO file, locate the EXE Updates folder
  4. Run Aurora Update Process.exe as an Administrator

    For SQL 2012, uninstall the components below:
    - Keyscan Aurora Database
    - Microsoft SQL Server 2008 Setup Support Files
    - Microsoft SQL Server 2012 (64 bit)
    - Microsoft SQL Server 2012 Native Client
    - Microsoft SQL Server 2012 Setup (English)
    - Microsoft SQL Server 2012 Setup Transact-SQL ScriptDom
    - SQL Server Browser for SQL Server 2012
    - Microsoft VSS Writer for SQL Server 2012

    For SQL 2017, uninstall the components below:
    - Keyscan Aurora Database
    - Microsoft SQL Server 2017 (64 bit)
    - Microsoft SQL Server 2012 Native Client
    - Microsoft SQL Server 2017 Setup (English)
    - Microsoft SQL Server 2017 Setup Transact-SQL ScriptDom
    - Browser for SQL Server 2017
    - Microsoft VSS Writer for SQL Server 2017

    For SQL 2017 only, rename the C:\DKTemp1\ folder to C:\Old -DKTemp1\
  5. Reboot the server after uninstalling the older SQL
  6. Within the new Aurora ISO file, locate the AuroraSetupFiles.
    Run KeyscanAuroraDatabaseSetup.exe as an Administrator

  7. Reboot the server

     

Use the following KB article to assist with restoring a backup

How Do I Move My Aurora Database To A New Server?

Related to