Upgrade from 3.10.2 to 3.15
This document will guide you to upgrade the windows based solution from 3.10.2. to 3.15.
You need to follow the following steps in order to upgrade the solution.
MongoDB Backup
We need to take the backup of MongoDB data. For this purpose, create a directory named mongo-backup in your desired location. In this example, it is created in C:\mongo-backup
- Install MongoDB tools from here.
- After installation is successful, run the following command in CMD:
- CODE
cd C:\Program Files\MongoDB\Tools\100\bin\ mongodump --out C:\mongo-backup
- Stop the currently running solution using Windows Service.
MSSQL DB Upgrade
After all the Services of Hybrid Chat are stopped, Open Microsoft SQL Server Management Studio and connect to the server your DB is present. Then follow the steps below:
- Take backup of database. Right Click on the DB and go to
task
and then selectbackup
. - When the back-up is done, select the database from drop down menu and click on New Query.
- Download & edit the upgrade-from-3.10.2-to-3.11.sql script. Set your database name in line # 2 of this script and execute it. If using SSMS, also select the HC 3.10.2 database from the Available Databases dropdown menu (Windows OS shortcut: Ctrl + U).
- Download and execute the update-from-3.11-to-3.12.1.sql script. Select HC 3.10.2 database before execution of the script in SSMS or SQL CMD.
- Download & execute the upgrade-from-3.12.1-to-3.13.0.sql script. This script does not set the database to the single-user mode so it is recommended to execute it via SSMS. Select to HC 3.10.2 database from the Available Databases dropdown menu in SSMS before proceeding. This script does not expect the database name. If you want to execute it via SQL CMD, select HC 3.10.2 database first before proceeding.
- Download & edit the upgrade-from-3.13.x-to-3.14.0.sql script. Set your HC FQDN in line # 4 in the script and execute using SSMS or SQL CMD. Select HC 3.10.2 database first before execution of the script in SSMS or SQL CMD.
- Download and execute the remove-uq-botname.sql script. Select HC 3.10.2 database first before execution of the script in SSMS or SQL CMD.
- The Database upgrade is completed.
Installation of Hybrid Chat
We will upgrade the Hybrid Chat by uninstalling (after taking backup) of old release and deploying the new release.
- When all the EF related services are stopped, remove them by the following command
SC DELETE <service-name>
- This will delete all the services. For removal of ActiveMQ, MongoDB, Tomcat and Java, please use Windows add or remove program utility.
- Take the backup of current deployment preferably by renaming it with
C:\hybrid-chat-3.10.2backup
or just deploy the solution in different directory using this guide. - After you are done with the installation of new release, we need to restore the MongoDB Backup that we have took earlier.
MongoDB Restore
For the MongoDB restore, please follow the following steps:
- Stop all the services by using Windows Services utility.
- Open CMD and run the following commands:
- CODE
cd C:\Program Files\MongoDB\Tools\100\bin\ mongorestore --verbose --drop C:\mongo-backup
CODEcd C:\Program Files\MongoDB\Server\4.4\bin use chatsolution db.agents.remove({})
- Start all the services using Windows Services utility.
That's it. You should have working Hybrid Chat release 3.15