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 the download document https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0078997.

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 OneTest API 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 Quality Server:
      • Download it from the Microsoft Developer Network website
      • Copy the sqljdbc41.jar file to the lib folder of the HCL Quality Server installation directory, for example, C:\Program Files\HCL\HCLProducts\QualityServer\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 HCL Quality Server:
      • Copy the jtds-1.2.5.jar file to the lib folder of the installation directory, for example, C:\Program Files\HCL\HCLProducts\QualityServer\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\lib
      • Restart the service