Upgrading system from IQ Bot 5.0.x to 5.1.x

Find out how to upgrade your system from IQ Bot 5.0.x to 5.1.x

Prerequisites

  • Perform the following tasks on a machine that has MS SQL database installed.
  • The MS SQL server database must belong to the same version on the source and destination database servers.
  • Before restoring the database, stop all IQ Bot services and ensure none of the services are running.
  • Have the migration utility available for use, consisting of the following batch files required for upgrade:
    • Backup_DB.BAT
    • Restor_DB.BAT
Note: The migration utility script supports migration of learning instances and bots from one IQ Bot v5.1.x installation instance to another IQ Bot v5.1.x installation instance. It does not work for migration from IQ Bot 5.0.x to IQ Bot 5.1.x.
This task walks you through the steps to upgrade your IQ Bot system from version 5.0.x to 5.1.x.

Procedure

  1. Back up the database using the Backup_DB.BAT file. The file contains the following:@ECHO OFFSETLOCAL REM Build a list of databases to backup FOR %%G IN (ClassifierData,FileManager,MLData) DO ( ECHO %%G.BAK SqlCmd -S ec5-55-555-555-555.ap-south-1.compute.amazonaws.com -U username -P password -Q "BACKUP DATABASE [%%G] TO Disk='C:\kj\%%G.bak'" ) ENDLOCAL .
    File objectsReference
    (ClassifierData,FileManager,MLData) Picks one or more databases to back up. Here all three databases are selected.
    ec5-55-555-555-555.ap-south-1.compute.amazonaws.com This is a placeholder for the MS SQL database server name. Replace it with your database server name.
    'C:\kj\ This is a placeholder for the output path of the backup files. Change this based on your requirements.
  2. To restore one or more back up files, copy all the database backup files (.bak) into the database server and run the following from the command-line: sqlcmd -S ec5-55-555-555-555.ap-south-1.compute.amazonaws.com -U username -P password -Q "RESTORE DATABASE AliasData FROM Disk='C:\IQBot_DB_Backup\AliasData.bak'
    File objectsReference
    ec5-55-555-555-555.ap-south-1.compute.amazonaws.com This is a placeholder for the MS SQL database server name. Replace it with the name of your database server.
    Change the backup file path depending on your requirements. Additionally, change the database user name and password depending on the settings of your database.