SQL Server Databases

From Seapine Labs

TestTrack is client/server application consisting of a client application, a server application, and a database. The TestTrack Server communicates with the Seapine License Server, which provides centralized license management and stores user information in a separate database. With any TestTrack installation, there are three types of databases: the Seapine License Server database, TestTrack Server database, and TestTrack project databases.

The Seapine License Server database stores product licenses, the global user list, and the server settings. You can use the Seapine License Server Admin utility to manage this database. The TestTrack Server database contains the project list, the mail queue, and TestTrack Server Options. The TestTrack project databases contain the configuration settings for individual projects, as well as defects, test cases, test runs, custom fields, local users, and security groups.

By default, all the applications use a proprietary database format. However, they can use any of the following RDBMS formats:

• SQL Server/ODBC
• MySQL
• Oracle Native

Note: You can mix database formats. For example, you can use the native database format for the server databases and MySQL for the TestTrack project databases.

This article describes how to configure the Seapine License Server and TestTrack Server to use ODBC (SQL Server) databases. Install the Seapine License Server, TestTrack Client, and TestTrack Server before configuring the databases.

To use SQL Server databases for the License Server or TestTrack Server, complete the following tasks:

• Create the database
• Creating the ODBC data source
• Configure the Seapine License Server and/or TestTrack Server to use a SQL Server database

To use SQL Server databases for one or more TestTrack projects complete the following tasks:

• Configure TestTrack to connect to a SQL Server project database
• Create a new TestTrack project for SQL Server

Contents 1 Creating the database 1.1 Creating the ODBC data source 2 Configuring the Seapine License Server and TestTrack for ODBC databases 2.1 Configuring the Seapine License Server to use a SQL Server database 2.2 Configuring the TestTrack Server to use a SQL Server database 2.3 Configuring TestTrack to connect to a SQL Server project database 2.4 Creating a new TestTrack project for SQL Server

[edit] Creating the database

Before configuring the databases with the appropriate admin utility, you must create the database. Keep the following in mind:

• Do not add, delete, or modify any of the fields in the Seapine License Server or TestTrack Server or TestTrack project tables.
• Do not directly add, edit, or delete any of the data in these tables.
• Do not create different primary keys. This will adversely affect the performance of the application.
• Do not create complex triggers on any of the Seapine License Server, TestTrack Server, or TestTrack project tables. Triggers may cause severe database issues, and correcting these issues is not covered by Seapine Software.
• Create a process to back up database tables on a regular schedule.

Log in to the RDBMS and create a new database for the databases (Seapine License Server, TestTrack Server, and/or TestTrack project database) you want to manage with the RDBMS.

Next decide which RDMBS user account you want the Seapine License Server and/or TestTrack Server to use to connect to the RDBMS. Determine whether you want to use a single account for all the databases or if you want to set up separate accounts for each. You can use an administrative account, but for security purposes, we recommend using a separate account with limited rights. Make sure any accounts you create have full control over the database and schema.

[edit] Creating the ODBC data source

On the computer running the TestTrack Server service, create ODBC Data Source Names (DSN) for each of the databases you will connect to. Use the following steps.

1. Choose Start > Settings > Control Panel.
2. Double-click Administrative Tools.
3. Double-click Data Sources (ODBC).
4. Click the System DSN tab then click Add.
5. Click SQL Server then click Finish.
6. Enter a unique Name and data source Description (optional).
7. Select the Server you want to connect to. The server must already contain a the Seapine Licence Server or TestTrack database.
8. Click Next.
9. Select an authentication option.
10. Select Connect to SQL Server to obtain default settings for the additional configuration option.
11. Enter the Login ID and Password of a user who has read/write/delete access to the SQL database.
12. Click Next.
13. Select the Change the default database to check box then select the database. Select the database you created to store the Seapine License Server, TestTrack Server, or project database. Do not use the default master database.
14. Select the Use ANSI quoted identifiers check box.
15. Select the Use ANSI nulls, paddings, and warnings check box.
16. Click Next.
17. Select the Perform translation for character data check box.
18. Click Finish.
19. Click the Test Data Source button. The connection is tested. A dialog box opens that displays the results.
20. Click OK to close the dialog box. Note: If the test connection fails, check the information then re-test the connection. It is important to make sure the connection succeeds before you continue.
21. Click OK to close the ODBC Data Source Administrator. The DSN is added to the list of System Data Sources.

[edit] Configuring the Seapine License Server and TestTrack for ODBC databases

After creating the databases, use the appropriate admin utility to convert the existing data to the new format. You may not use all the following procedures depending on which databases you chose to convert.

[edit] Configuring the Seapine License Server to use a SQL Server database

The Seapine License Server database stores product licenses, the global user list, and the server settings. If you created a SQL Server database for the Seapine License Server, use the following steps to convert the existing data.

1. Choose Programs > Seapine Software > Seapine License Server > Seapine License Server Admin on the Start menu.
2. Click Server Options.
3. Click the Server Database category.
4. Click Convert. The License Server Database Conversion dialog box opens.
5. Select ODBC as the Database Type.
6. Select a Data Source Name.
7. Enter your Username and Password.
8. Click Test.
9. Click OK. The Conversion Confirmation dialog box opens.
10. Click Use the converted database to end your administration session after the database is converted.
11. Click Yes. The RDBMS Vendor dialog box opens.
12. Select a database vendor.
13. Click OK.
14. Click OK in the Success dialog box.
15. Click Close in the Conversion Status dialog box.

[edit] Configuring the TestTrack Server to use a SQL Server database

The TestTrack Server database contains the project list, the mail queue, and TestTrack Server options. If you created a SQL Server database for the TestTrack Server, use the following steps to convert the existing data.

1. Choose Programs > Seapine Software > TestTrack > TestTrack Server Admin on the Start menu.
2. Click Server Options. The Options dialog box opens.
3. Click Server Database.
4. Click Convert. The License Server Database Conversion dialog box opens
5. Select ODBC as the Database Type.
6. Select a Data Source Name.
7. Enter a Username and Password.
8. Click Test.
9. Click OK.

[edit] Configuring TestTrack to connect to a SQL Server project database

TestTrack project databases contains the configuration settings for individual projects, as well as defects, test cases, test runs, custom fields, local users, and security groups. Use the following steps to configure to TestTrack Server to connect to the RDBMS that contains the SQL Server project databases.

1. Choose Programs > Seapine Software > TestTrack > TestTrack Server Admin on the Start menu.
2. Click Server Options. The Options dialog box opens.
3. Select RDBMS Connections in the Servers category.
4. Click Add to add a new RDBMS connection.
5. Select ODBC as the Connection Type.
6. Select a Data Source Name.
7. Enter the Username and Password.
8. Click Test.
9. Click OK to add the connection.
10. Click OK in the Options dialog box.

[edit] Creating a new TestTrack project for SQL Server

1. Choose Programs > Seapine Software > TestTrack > TestTrack Server Admin on the Start menu.
2. Click Projects.
3. Click Create.
4. Enter a Description.
5. Select RDBMS as the Project Type.
6. Select a Connection.
7. Click OK to save the changes.