Run IQ Bot On-Premises database migration script

IQ Bot On-Premises Builds 1089, 1598, and 2079 included five databases. Starting with IQ Bot On-Premises Build 2545, one unified database is supported. You have to run a migration script to migrate the databases of Builds 1089, 1598, 2079 to the latest build.

Prerequisites

Before you run the migration script, you must be on the latest IQ Bot On-Premises build, and verify that the SQL command utility SQLCMD.exe is installed on your system.

Also, verify and ensure Microsoft ODBC Driver 17 for SQL Server is installed on the IQ Bot server. This can be obtained from: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

  1. Uninstall the current build of IQ Bot On-Premises.
  2. Install the latest IQ Bot On-Premises build.

    During installation, a new IQ Bot database is created.

    Note: Remember your database username and password in order to the update migration script value.
  3. Navigate to your Binn folder.

    This might be located in C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn.

  4. Verify that SQLCMD.exe is installed.
    If SQLCMD.exe is not installed, follow these steps:
    1. Download and extract the Data Migration.zip from the Installation Setup folder onto the IQ Bot server.
    2. Navigate to DataMigration > UTILITY-MsSqlCmdLnUtils.
    3. Run MsSqlCmdLnUtils.msi to install SQLCMD.exe.

After SQLCMD.exe is installed, run the migration script.

Procedure

  1. Access the AA.IQBot_Database_Migration.bat file within the DataMigration folder.
  2. Edit the AA.IQBot_Database_Migration.bat file.
  3. Update the values as follows:
    1. Set the SQLCMD value to the path of your Binn. 
      
                     SQLCMD="C:\Program Files\Microsoft SQL Server\Client
                                SDK\ODBC\170\Tools\Binn\SQLCMD.exe"
                  
      
                  
               
      2. 
               
    2. 
                  Set LOGIN value to your database username.
                  
      
                     LOGIN="database username"
                     
      Note: The
                                    bulkadmin,
                                    dbcreator, and
                                    public roles are required to run the
                                migration script.
      
                  
      
               
      3. 
               
    3. 
                  Set the PASSWORD value to your database
                            password.
                  
      
                     PASSWORD="database password"
                  
      
               
      4. 
               
    4. 
                  Set the SERVER value to the path of your database
                            server hostname.
                  
      
                     SERVER="path of database server hostname"
                  
      
               
      5. 
            
    
            
         
  4. 
            Run the migration script AA_IQBot_Database_Migration.bat
                    file with administrator privilege.
            
    After the migration is complete, an output is created. Verify
                        C:\Datamigrationlog.txt for log history and
                        errors.
    Note: If an output is not displayed, contact
                    support.