Difference between revisions of "AquilaServer New Install and Migration"

From EHS Help
Jump to: navigation, search
m (Admin moved page Server Migration to Aquila Server New Install and Migration: Better description)
Line 1: Line 1:
  
  
 +
=== Migrating ===
  
−
The following steps are to migrate the AquilaServer product from one server to another.
+
To migrate AquilaServer, perform a new install of AquilaServer on the new server and enter your existing database connection settings.
  
−
• Make a copy of the `AquilaServer.ini` file from the old server installation directory, to retain your current settings information.
+
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`
  
−
• Download the AquilaServer installation from www.EvolutionHealthcareSystems.co.uk/downloads - (login is required -- please [[Contact Us]])
+
This file will contain a line similar to below:
  
−
• Run the AquilaServer Installation on your server:
+
    ConnectionString=AnyDAC?AuxDriver=MSSQL;Server='''my_database_server\my_instance_name''';Database='''ibid_data''';UserId='''ibid_login''';password='''xyz123'''
  
−
• The installation will ask for the name of the SQL Server and Database, and for the SQL Server Login information. Input the requested information into the installer using the information in the `AquilaServer.ini` file, from the line `ConnectionString=....`
+
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 UserId or Password parameter - in which case leave these fields blank during installation
 +
ii. You're server name may not have an instance name
 +
 
 +
 
 +
=== AquilaServer 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.
  
 
[[File:AquilaServerInstallationDatabaseDetails.png]]
 
[[File:AquilaServerInstallationDatabaseDetails.png]]
Line 16: Line 30:
 
[[File:AquilaServerInstallationLoginDetails.png]]
 
[[File:AquilaServerInstallationLoginDetails.png]]
  
−
• Note, if your current Connection String has no user id or password parameters, but has "Integrated Security=SSPI" instead, just leave the user id and password fields blank & press Next.
+
If you are migrating from an old installation, enter the settings from your old server (see above).
 +
 
 +
 
 +
=== Client Update ===
 +
 
 +
 
 +
Distribute the new server URL to your users, where it can be updated on the login screen.
 +
 
 +
The new server URL will be:
  
−
• For further installation details please see [[Aquila Server Installation]]
+
    http:\\'''new-server-name''':8099/bin
  
−
• Distribute the new server URL to your users, where it can be updated on the login screen.
 
  
−
When the new installation is confirmed and working:
+
(The default port number is 8099; if you have changed this then make the changes in the above URL).
  
−
• Uninstall aquilaserver from the old server.
+
When the new installation is confirmed and working you can uninstall aquilaserver from the old server & decommission as needed.
  
  

Revision as of 10:35, 18 May 2020


Migrating

To migrate AquilaServer, perform a new install of AquilaServer on the new server and enter your existing database connection settings.

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 UserId or Password parameter - in which case leave these fields blank during installation ii. You're server name may not have an instance name


AquilaServer 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).


Client Update

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=6834’