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 section in the System Requirements page.
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 IBM® Rational® Integration Tester 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.
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.
Note: If necessary,
the SQL Server 2005 driver (sqljdbc.jar) can be downloaded
from the Microsoft Developer
Network website.
Note: If you plan to use SQL
Server as a project results database in IBM Rational Test Control Panel,
copy the jtds-1.2.5.jar file to the lib folder
of the Rational Test Control Panel installation
directory (for example, C:\Program Files\IBM\RationalTestControlPanel\lib),
and then restart the service.