Resolving The Problem

The following steps summarize the steps to migrate a project to DB2.

Migration to DB2

1. Open Rational Administrator
2. Register the project, if the project is absent on the list
3. Connect to the project
4. Right click on Rational TestDatastore then click properties
5. Click the button Advanced Database Setup
6. In the Advanced Database Setup select the check box Use IBM DB2 UDB for database engine
7. Type in the Database Alias and your credentials
8. Click OK

Migrating SQL Anywhere to MS Access
Note: SQL Anywhere databases must be migrated prior to upgrading to Rational TestManager 2003.06.16 and higher as SQL Anywhere is not supported after the 2003.06.15 versions.

To migrate to a Microsoft Access database, initialize the testdatastore and the testusersandgroups from the SQL Anywhere project. This is the step by step description.

1. Open Rational Administrator
2. Register the SQL Anywhere project, if the project is absent on the list
3. Create a new project
4. Configure the project
5. In the dialog box Configure Project, click the Create button in the section Test Assets
6. In the dialog box Create Test Datastore (Page 1 from 4) select the check box Microsoft Access
   
   
   
7. Click Next
8. Leave the new Testdatastore path unchanged, then click Next
9. Select the check box Enable initialize assets from the following datastore
   
   
10. Click Browse to select the testdatstore folder of the SQL Anywhere project
11. Select the check box Enable initialize test users and groups from the Rational project
12. Click Browse to select the TestUsersAndGroups folder of the SQLAnywhere project
13. Click Next
14. Verify in the next dialog box, if you made the right choices
15. Click Finish

Note: The choice between MS Access and DB2 depends on what the purpose is of your test project. In most cases MS Access is suitable for demonstration and testing purposes. For production, a DB2 database might be preferable.