Difference between revisions of "AquilaServer New Install and Migration"

From EHS Help
Jump to: navigation, search
m (→‎Database Migration)
 
(21 intermediate revisions by 2 users not shown)
Line 1: Line 1:
  
−
==Application Server Migration==
 
  
−
* Stop and disable existing aquilaserver service to prevent further user access.
+
== Migrating ==
−
* 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==
+
'''Overview'''
  
−
* Ensure new server has SQL Server installed and available
+
Migrating AquilaServer between servers requires you to make a note of the existing AquilaServer settings, perform a new install of AquilaServer on the new server and enter the existing configuration.
−
* 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]].
+
−
* 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.
+
  
−
==Database and Server Migration==
+
Finally you run the "DB Upgrade Check" to make sure the database version matches the version of AquilaServer you just installed.
  
−
* Install SQL server on new server (if not already) but do not create database.  Create a new login for AquilaServer (unless using integrated authentication. For more info please see [[Creating a SQL Server Login]]).
 
−
* Stop and disable existing aquilaserver service to prevent further user access.
 
−
* Backup database on old server
 
−
* Transfer & restore database to new server
 
−
* Install aquilaserver on new server. For further details please see [[Aquila Server Installation]]
 
−
* Configure aquilaserver with the database connection.  For further details please see [[Aquila Server Installation]]
 
−
* Update each client with the new server URL (via the F2 option on login screen)
 
  
 +
'''Copying Existing Server Config'''
  
−
<!-- [[File:LoginScreen.jpg]] -->
+
Your current database connection settings can be found on your ''old server'' in the file `c:\program files (x86)\Evolution Healthcare Systems Limited\AquilaServer\AquilaServer.ini`
 +
 
 +
This file will contain a line similar to below:
 +
 
 +
    ConnectionString=AnyDAC?AuxDriver=MSSQL;Server='''my_database_server\my_instance_name''';Database='''ibid_data''';UserId='''ibid_login''';password='''xyz123'''
 +
 
 +
The Server Name, Database Name and the User id and password are highlighted and should be entered during the new installation.
 +
 
 +
''i. You may not have a User Id or Password parameter - in which case leave these fields blank during installation<br>
 +
''ii. Your server name may not have an instance name''<br>
 +
''iii. Settings can be adjusted after installation if necessary'''
 +
 
 +
Now run the AquilaServer installation the new server (below); then the Database Upgrade Check afterwards (see below).
 +
 
 +
 
 +
== AquilaServer New Installation ==
 +
 
 +
 
 +
• Download the AquilaServer installation from www.EvolutionHealthcareSystems.co.uk/downloads - (login is required -- [https://www.evolutionhealthcaresystems.co.uk/contact/ please contact us for a login])
 +
 
 +
• Run the AquilaServer Installation on your server
 +
 
 +
• The installation will ask for the name of the SQL Server and Database, and for the SQL Server Login information.
 +
 
 +
[[File:AquilaServerInstallationDatabaseDetails.png]]
 +
 
 +
[[File:AquilaServerInstallationLoginDetails.png]]
 +
 
 +
If you are migrating from an old installation, enter the settings from your old server (see above).
 +
 
 +
 
 +
=== Database Upgrade Check ===
 +
 
 +
If you're migrating from an old server and you've installed a newer version than you had previously please run the "DB Upgrade Check" after installation (available in the start menu).
 +
 
 +
This shortcut is located in the start menu in the ''Aquila Server'' group.  No user input is required.  Should take no more than a few minutes to complete.
 +
 
 +
 
 +
=== Client Update ===
 +
 
 +
 
 +
If the server DNS name or port number has changed, you may need to distribute the new server URL to your users, where it can be updated on the login screen.
 +
 
 +
The new server URL will be:
 +
 
 +
    http:\\'''new-server-name''':8099/bin
 +
 
 +
 
 +
(The default port number is 8099; if you have changed this then make the changes in the above URL).
 +
 
 +
When the new installation is confirmed and working you can uninstall aquilaserver from the old server & decommission as needed.
 +
 
 +
 
 +
<hr>
 +
 
 +
See also [[Database Migration]].

Latest revision as of 14:25, 4 February 2025


Migrating

Overview

Migrating AquilaServer between servers requires you to make a note of the existing AquilaServer settings, perform a new install of AquilaServer on the new server and enter the existing configuration.

Finally you run the "DB Upgrade Check" to make sure the database version matches the version of AquilaServer you just installed.


Copying Existing Server Config

Your current database connection settings can be found on your old server in the file `c:\program files (x86)\Evolution Healthcare Systems Limited\AquilaServer\AquilaServer.ini`

This file will contain a line similar to below: 

   ConnectionString=AnyDAC?AuxDriver=MSSQL;Server=my_database_server\my_instance_name;Database=ibid_data;UserId=ibid_login;password=xyz123

The Server Name, Database Name and the User id and password are highlighted and should be entered during the new installation.

i. You may not have a User Id or Password parameter - in which case leave these fields blank during installation
 ii. Your server name may not have an instance name
iii. Settings can be adjusted after installation if necessary'

Now run the AquilaServer installation the new server (below); then the Database Upgrade Check afterwards (see below).


AquilaServer New Installation

• Download the AquilaServer installation from www.EvolutionHealthcareSystems.co.uk/downloads - (login is required -- please contact us for a login)

• Run the AquilaServer Installation on your server

• The installation will ask for the name of the SQL Server and Database, and for the SQL Server Login information.

AquilaServerInstallationDatabaseDetails.png

AquilaServerInstallationLoginDetails.png

If you are migrating from an old installation, enter the settings from your old server (see above).


Database Upgrade Check

If you're migrating from an old server and you've installed a newer version than you had previously please run the "DB Upgrade Check" after installation (available in the start menu).

This shortcut is located in the start menu in the Aquila Server group. No user input is required. Should take no more than a few minutes to complete.


Client Update

If the server DNS name or port number has changed, you may need to distribute the new server URL to your users, where it can be updated on the login screen.

The new server URL will be: 

   http:\\new-server-name:8099/bin


(The default port number is 8099; if you have changed this then make the changes in the above URL).

When the new installation is confirmed and working you can uninstall aquilaserver from the old server & decommission as needed.


See also Database Migration.

Retrieved from ‘https://evolutionhealthcaresystems.co.uk/help/index.php?title=AquilaServer_New_Install_and_Migration&oldid=7008’