Difference between revisions of "AquilaServer New Install and Migration"

From EHS Help
Jump to: navigation, search
(Application Server Migration)
(Database Migration)
Line 10: Line 10:
  
 
==Database Migration==
 
==Database Migration==
 +
 +
The following steps are for migrating your database whilst keeping the application server in the same location:
  
 
* Ensure new server has SQL Server installed and available
 
* Ensure new server has SQL Server installed and available
* Create a new login for the AquilaServer service to connect with, unless using integrated authentication. For more info please see [[Creating a SQL Server Login]].
+
* If you're using SQL Server Logins; create a new login for the AquilaServer service to connect that matches your previous installation. For more info please see [[Creating a SQL Server Login]].
 
* Stop the Aquilaserver service on the application server to prevent user access.
 
* Stop the Aquilaserver service on the application server to prevent user access.
 
* Backup database on old server
 
* Backup database on old server

Revision as of 13:50, 5 February 2020

Application Server Migration

  • Stop and disable existing aquilaserver service to prevent further user access.
  • At this point, backup & migrate your database using the steps below.
  • Install aquilaserver on new server. For further details please see Aquila Server Installation
  • Copy the `AquilaServer.ini` file from the old server installation directory, to the new, in order to easily preserve your settings.
  • Uninstall aquilaserver from the old server.
  • Distribute the new server URL to your users, where it can be updated on the login screen.

Database Migration

The following steps are for migrating your database whilst keeping the application server in the same location:

  • Ensure new server has SQL Server installed and available
  • If you're using SQL Server Logins; create a new login for the AquilaServer service to connect that matches your previous installation. For more info please see Creating a SQL Server Login.
  • Stop the Aquilaserver service on the application server to prevent user access.
  • Backup database on old server
  • Transfer & restore database to new server
  • Edit the aquilaserver.ini file in the installation folder on the application server to reflect the new database location
  • Restart the AquilaServer service.
  • AquilaCRS client re-configuration is not necessary.