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