Developing and Deploying Siebel Business Applications > Migrating to the Test Environment > Migrating Repository Data from Development to Test >

Migrating the Repository


The Repository Migration Configuration Utility is a wizard that prompts you for the required information as you proceed through a succession of dialog boxes. You launch the Repository Migration Configuration Utility from the Siebel Database Configuration Utility. When the configuration session completes, the migration can be executed immediately or at a later time using the command line.

To migrate a repository

  1. Launch the Database Server Configuration Utility by choosing Start > Programs > Siebel Enterprise Server version_number > Configure DB Server.

    The Gateway Server Address screen appears.

  2. Specify your Siebel Gateway Name Server Address and Enterprise Server Name and click Next.

    The Siebel Server Directory screen appears.

  3. In the Siebel Server Directory screen, either accept the default value or choose the Browse button to select a directory, and then click Next.

    The Siebel Database Server Directory screen appears.

  4. In the Siebel Database Server Directory screen, either accept the default value or choose the Browse button to select a directory, and then click Next.

    The RDBMS Platform screen appears.

  5. In the RDBMS Platform screen, select the platform for your environment and then click Next.

    The Siebel Database Operations screen appears.

  6. In the Siebel Database Operations screen, select Migrate Repository from the list of operations, and then click Next.

    The following succession of screens appears.

  7. Progress by completing the information as shown in the following table, and then clicking Next.
    Screen
    Description

    ODBC Data Source Name

    Enter the ODBC data source name.

    Database User Name

    Enter the source database user name and source database password.

    Database Table Owner

    Enter the source database table owner and source table owner password.

    Source Database Repository Name

    Enter the database repository name and the target database repository name.

    Target RDBMS Platform

    Select the target RDBMS platform. IBM DB2 UDB v7.1 is the default.

    Target Database Encoding

    Select whether the target database is Unicode.

    Target Database ODBC Datasource

    Enter the target database ODBC datasource.

    Target Database User Name

    Enter the target database user name and password.

    Target Database Table Owner

    Enter the target database table owner and table owner password.

    Index Table Space Name

    (DB2-specific)

    Applicable only if you indicated that the target database is IBM DB2.

    Enter the index table space name and 4-KB Table Space Name.

    16-KB Table Space Name

    (DB2-specific)

    Applicable only if you indicated that the target database is IBM DB2.

    Enter the 16-KB table space name and 32-KB table space name.

    Index Table Space Name

    (Oracle-specific)

    Applicable only if you indicated that the target database is Oracle. There are two questions about index and table space. There are no 4-KB, 16-KB, and 32-KB table spaces in Oracle.

    For Microsoft SQL server, there are no screens about table spaces.

    Configuration Parameter Review

    Summary screen gives a list of your choices. You can accept this configuration by clicking finish.

Developing and Deploying Siebel Business Applications Copyright © 2006, Oracle. All rights reserved.