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

1. Install MongoDB tools from here.
2. After installation is successful, run the following command in CMD:
3. CODE

   cd C:\Program Files\MongoDB\Tools\100\bin\
   mongodump --out C:\mongo-backup

4. 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:

1. Take backup of database. Right Click on the DB and go to task and then select backup.
2. When the back-up is done, select the database from drop down menu and click on New Query.
3. 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).
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.

1. When all the EF related services are stopped, remove them by the following command
   1. SC DELETE <service-name>
2. This will delete all the services. For removal of ActiveMQ, MongoDB, Tomcat and Java, please use Windows add or remove program utility.
3. 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.
4. 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:

1. Stop all the services by using Windows Services utility.
2. Open CMD and run the following commands:
   1. CODE

      
      cd C:\Program Files\MongoDB\Tools\100\bin\
      mongorestore --verbose --drop C:\mongo-backup

      CODE

      cd C:\Program Files\MongoDB\Server\4.4\bin
      use chatsolution
      db.agents.remove({}) 

3. Start all the services using Windows Services utility.

That's it. You should have working Hybrid Chat release 3.15