Question
How do I move my Aurora database to a new server?
Answer
Important:
Before moving a database, consider optional features that are not included in this process.
- E-Plex Integrations
- Enhanced Lockdown
- SDK/API Integrations
- Web Interface
- Reverse Network Communications
Please contact Support for assistance with database moves containing these features.
Process:
The following steps are a guide to moving a basic installation to a new server.
- Install Aurora on the new server (Database, Client, Agent, and Standard Communications). Refer to the specifications for supported Microsoft Operating Systems. Non-Microsoft Operating Systems are only supported via a virtualized environment. EAUR-UP is available through distribution and will be the most current SQL offering.
Server Specification - SQL Server 2012
Server Specification - SQL Server 2017
Server Specification - SQL Server 2022
- On the original server, access Services. Do this by pressing the Windows key and the R key at the same time. In the Run Command dialogue box type “services.msc” and press Enter. Stop the following services and close the Aurora Client. Set the startup type of the services to “Disabled” to avoid future conflicts.
Keyscan Aurora Agent
Keyscan Aurora Communications
- On the original server, do a backup with the database maintenance utility
- C:\Program Files (x86)\Keyscan\Keyscan Aurora Database\Keyscan Aurora Database Maintenance.exe
- Copy the backup to a network location or thumb drive. The default backup location is (where “xx” represents the 2-digit SQL version code).
- C:\Program Files\Microsoft SQL Server\MSSQLxx.AURORA\MSSQL\Backup\
- On the new server, install Aurora.
Keyscan Aurora Software Installation
- On the new server, place the backup into the same folder (where “xx” might be different).
- On the new server, access Services and stop the following services and close the Aurora Client.
Keyscan Aurora Agent
Keyscan Aurora Communications
- On the new server, use the database maintenance utility to restore the backup up.
- After the database has been restored, start the services that were stopped.
- After starting the services, launch the Aurora Client and navigate to the Hardware Setup screen.
- Navigate to each device and update the Communications Server to the correct server's name.
- Click the Save button at the bottom right of the screen. Repeat this process for all devices.
- Remote Clients will need to be updated to the new server name/IP address.
Keyscan Aurora Remote Client Management
- Firewall rules on the new server might be required.
What Ports Does Keyscan Aurora Use?
- Contact Support for assistance if required.