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 the download document https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0078997.
section inAbout 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
- 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.
- 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 thelib
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 thelib
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
- Copy the
- If you plan to use the SQL Server 2005 standard driver (