HCL Workload Automation, Version 9.4

Procedure to upgrade the HCL Workload Automation SQL schema on Microsoft SQL Server when using SQL Server Authentication

Before upgrading the HCL Workload Automation database schema, perform the following steps:
  1. Verify the current properties file and customize the SQL properties with the values appropriate for your needs. See Customizing the properties file for Microsoft SQL Server.
  2. Generate the SQL files. See Generating the SQL files on Microsoft SQL Server.
To upgrade the HCL Workload Automation database schema when using SQL Server Authentication, perform the following steps:
  1. Go to the following directory:
    TWSTEMPDIR\TWS\dbtools\mssql\scripts

    Where TWSTEMPDIR is the directory you specified in the TWSTEMPDIR property of the configuration file.

  2. Run the following command:
    migratedb_root.bat 
    <sqlServerInstance> <windowsAuthMode>
    <twsDatabase> <adminUser>
    <adminPwd> <agentType>

    Where:
    <sqlServerInstance>
    The name of the SQL Server instance.
    <windowsAuthMode>
    Specifies if Windows authentication is used to connect to SQL Server. Enter FALSE if you are authenticating as SQL Server user.
    <twsDatabase>
    The name of the database.
    <adminUser>
    The user name of the database administrator.
    <adminPwd>
    The password of the database administrator.
    <agentType>
    The type of HCL Workload Automation component for which you are upgrading the SQL tables. Enter MDM for a master domain manager, or BKM for a backup master domain manager.