The Decommission of Server feature in Jarrison Time enables the migration of the JTime database cluster from a running server to a new server, without having to individually change all user machine configuration files to point to the new server. The major versions of JT on both servers must match, and the server names/IPs must be different.
To begin the transfer, follow the below steps. Some understanding of restoring databases in Microsoft SQL is recommended.
Backup old system
1) Log into JT connected to the current server.
2) Make a full system backup (From the menu bar go to Action > Backup Database > Full System)
3) Copy backup zip file over to new server. JT Manager could be used to assist with the below steps.
4) Restore all databases in Full system backup folder (creating a replica of the current server)
Ensure that the naming convention on the new server matches the current server.
Decommission old system
1) After backing up, login to Jarrison Time on the current server.
2) From the menu bar go to Setup, System Configuration, and then the General-2 tab.
3) Select the box next to Decommission and route users to new SQL Server.
4) Click Test Connection to check the connection is working.
5) Close JT and launch again.
After clicking on ‘OK’ a warning message as below will appear
6) Log out of Jarrison Time.
Connect new server
Log in to Jarrison Time again, the following message will appear:
After OK is clicked Jarrison Time will connect with the new server.
Once JT is connected to the new server, do the following:
Check for clockings, adjustments and audit entries for each year that you had to restore a Log database
If there are no entries, there is a possibility the database restoration has not been done correctly.