Aurora Full SQL Upgrade

When To Consider The Aurora Full SQL Upgrade

Full SQL for Aurora should be considered when any of the following criteria are met:

• Multiple concurrent connections to the database (Clients, Web, SDK/API)
• Performance is notably impacted by SQL Express limitations
• Data needs to be maintained, exceeding the 10gb SQL Express limit
• Database often requires purging
• Photos are being utilized in larger installations
• Panel count exceeds 50-75 units

* Direct access to the Aurora database is not permitted

* Mounting of the Aurora database instance to another SQL Server installation is not permitted

Requirements For Upgrading Aurora To Full SQL

When the decision to upgrade to full SQL has been made, the following items are required:

1. Aurora version 1.0.16.0 or newer
2. Aurora licence EAUR-SQLUPG
3. Full SQL medium (purchased separately from Microsoft) that matches the existing installation
   • SQL 2012 Standard/Enterprise (64-bit) *Legacy
   • SQL 2017 Standard/Enterprise (64-bit)
   • SQL 2022 Standard/Enterprise (64-bit)

Procedure To Upgrade Aurora SQL To Full SQL

1. Register the AUR950 licence
2. Close any Client connections
3. Stop any Keyscan services
4. Launch the Keyscan Aurora Database Maintenance utility
5. Backup the database
6. Click on the SQL Server Upgrade button
7. Browse to the SQL medium & select the setup.exe
8. Follow the prompts to complete the upgrade
9. Backup the database once complete
10. Restart the Keyscan services
11. Launch the Client & verify the upgrade via Database Maintenance or Help>About