Resolving The Problem

Data Transport Wizard

The Data Transport Wizard, rqdatatransportwiz.exe, which is located in the <Installation Drive>\Rational\RequisitePro\bin can be used to move a project from one database vendor (Microsoft Access, SQL Server, Oracle or DB2) to another or to the same database vendor (Microsoft Access, SQL Server, Oracle or DB2).

Note: The wizard moves one project at a time.

Prerequisites

The Data Transport Wizard requires that the following conditions be met before you attempt to move a project between databases or database vendors.
Note: The wizard displays messages to alert you if any conditions are not met.

• The project must be saved in the current version of RequisitePro.
• You must have administrator permission's for the project.
• You must have log on and write permission's for the target database.
• Your database administrator must supply you with the user name and password, a server name, and a schema name so that you can access an enterprise database.
  

Important Considerations

• Make sure all RequisitePro users have closed the project before you continue.
• It is strongly recommend that you archive your project before you move it to another database.
  File > Project Administration > Archive > RequisitePro Archive.

Procedure for using the Data Transport Wizard to move a Project to an Enterprise Databases vendor

1. Configure a new, destination RequisitePro database (Microsoft Access, SQL Server, Oracle or DB2), using one of the following guidelines:
   
   For RequisitePro versions 7.0.0.0 and 7.0.1 the documentation for database setup is located in the installation and upgrade guide. This document can be located in the following directory.
   
<install dir>\Rational\RequisitePro\doc\books\rp_install.pdf

2. For RequisitePro versions 2003.06.xx the documentation is located in the following directories.
• SQL Server guidelines located in:
  
\Program Files\Rational\RequisitePro\help\sqlsetup.html

• Oracle Server guidelines located in:
  
\Program Files\Rational\RequisitePro\help\oraclesetup.html

• DB2 Server guidelines located in:
  ***Only available in v2003.06.13 and above***
  
\Program Files\Rational\RequisitePro\help\DB2setup.html

3. Open the Data Transport Wizard, rqdatatransportwiz.exe in Windows Explorer.
   The rqdatatransportwiz.exe, is located in:
   
\Program Files\Rational\RequisitePro\bin\

4. Click Next at the first Data Transport Wizard screen, and then click the Browse button to select the project you want to move.
5. At the Project/database screen, click the Choose button to open the Database Properties dialogue box.
6. Selecting the database Type. Choose the destination database type you have setup for this move:

Moving to SQL Server steps:

1. Select SQL Server as the Type and click the Configuration button.
2. In the Create a New Data Source to SQL Server dialogue box, do not modify the Name or Description.
3. In the Server field, type the name of the SQL Server, supplied by your database administrator then click Next.
4. Select the option With SQL Server authentication using a logon ID and password entered by the user.
   Note: RequisitePro does not support Windows NT authentication.
5. Be sure the check box Connect to SQL Server to obtain default settings for the additional configuration options is selected.
6. Type a logon ID and password, supplied by your database administrator, such as ReqPro and reqpro then click Next.
7. Select the check box Change the default database to and select a database name supplied by your database administrator, such as RequisitePro then click Next.
8. Accept the default language, character, and regional settings and click Next.
9. The use of log files, shown on the screen that appears, is optional.
   Note: Do not select the check box Change the language of SQL Server system messages to... The use of this check box prevents users from opening the project after its initial creation then click Finish.
10. In the ODBC Microsoft SQL Server Setup dialogue box, click the Test Data Source button. Click OK in the SQL Server ODBC Data Source Test dialogue box. Then click OK to return to the Data Transport Wizard project/database screen.
11. Click Account Info to enter database account information, and follow the remaining screens, view the Conversion Report, and exit the wizard.

Moving to Oracle Server steps:

1. Select Oracle as the Type and click the Configuration button.
2. The Microsoft ODBC for Oracle Setup dialogue box appears.
   Note: Do not modify the default entries in the Data Source Name and Description fields.
3. Type your User Name for logging on to the Oracle database.
   This should be supplied to you by your Oracle database administrator.
4. For the Server field, type the alias you created when configuring your machine, for example, OracleDB.
5. Click OK to return to the Data Transport Wizard project/database screen.
6. Click the Account Info button to enter database account information, follow the remaining screens, view the Conversion Report, and exit the wizard.

Moving to DB2 Server steps:

***DB2 is only available in RequisitePro v2003.06.13 and above***
1. Select DB2 as the Type and click the Configuration button.
2. The Microsoft ODBC for DB2 Setup dialog box appears.
   Note: Do not modify the default entries in the Data Source Name and Description fields.
3. Type your User Name for logging on to the DB2 database. This should be supplied to you by your DB2 database administrator.
4. For the Server box, type the alias you created when configuring your machine, for example, DB2DB.
5. Click OK to return to the Data Transport Wizard project/database screen.
6. Click the Account Info button to enter database account information, follow the remaining screens, view the Conversion Report, and exit the wizard.