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:
- If the installation uses Full SQL, contact Support to assist with the upgrade
- These instructions are for Aurora installations only, not Aurora with integrations
- Method 2 will break other SQL installations on the Aurora server; consider Method 1
- Instructions are for single-server installations. Large-scale installations should contact Support
- E-Plex, SDK/API, Web, AD Integration & remote connections need to be considered; contact Support
- 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 guide.
Installing Keyscan Aurora Software
How Do I Move My Aurora Database To A New Server?
Method 2 (not recommended)
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.
Stop the Keyscan Aurora services via services.msc & close the Aurora Client.
Within the new Aurora ISO file, locate the EXE Updates folder.
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\
Reboot the server after uninstalling the older SQL
Within the new Aurora ISO file, locate the AuroraSetupFiles.
Run KeyscanAuroraDatabaseSetup.exe as an Administrator.
Reboot the server.
Use the following KB article to assist with restoring a backup.