Creating the project results database by using Microsoft SQL Server

You can create project results databases by using Microsoft SQL Server.

Before you begin

For information about the supported versions of the database, see the Supported Software > Database section in Supported software

About this task

The current version of the ghtester_mssql.sql script provides Unicode support. To update SQL project results databases that were created before HCL DevOps Test Integrations and APIs (Test Integrations and APIs) version 8.5.0 to change varchars to nvarchars so that Unicode is supported, run the patch-1_9_24_d-1_9_24_e_mssql.sql script.

To update SQL project results databases to the latest database schema, run the patch-1_9_24_e-1_9_24_f_mssql.sql script.

Procedure

  1. Create the database using the collation option of SQL_Latin1_General_CP437_CI_AS to enable use of the UTF-8 character set. For more information, refer to the Microsoft SQL Server documentation.
  2. Run the ghtester_mssql.sql script against the new database.
    Notes:
    • If you plan to use the SQL Server 2005 standard driver (sqljdbc41.jar) as a project results database in HCL DevOps Test Virtualization Control Panel (Test Virtualization Control Panel):
      • Download it from the Microsoft Developer Network website
      • Copy the sqljdbc41.jar file to the lib folder of the Test Virtualization Control Panel installation directory, for example, C:\Program Files\HCL\DevOpsTestControlPanel\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\lib
      • Restart the service
    • If you plan to use the SQL Server open source driver (jtds-1.2.5.jar) as a project results database in Test Virtualization Control Panel:
      • Copy the jtds-1.2.5.jar file to the lib folder of the installation directory, for example, C:\Program Files\HCL\DevOpsTestControlPanel\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\lib
      • Restart the service