Bookshelf Home | Contents | Index | PDF     

Using Siebel Tools > Managing Repositories >

Exporting and Importing Repositories Using the Database Configuration Wizard

To export and import the entire repository, you use the Database Configuration Wizard. This is typically used for backing up and restoring and for moving the contents of a repository to a repository in an another environment, when both the source and the target environment have the same physical database schema and Siebel release version.

For more information on launching the Database Configuration Wizard, see the Siebel Installation Guide for the operating system you are using.

When importing and exporting using the Database Configuration Wizard, consider the following:

  • When you are importing a custom repository (not the standard Siebel repository), all languages which were part of the original repository are restored during import. For example, if you archive repositories weekly and your development repository contains support for both ENU and DEU, then both ENU and DEU are included when one of the archived repositories is imported.
  • Whenever you make a change to the repository, compile all projects that belong to the latest version of the repository to create an updated SRF file. Keep a backup of the SRF file, so you can be sure the SRF file truly reflects the contents of the updated repository.
  • If you need to back up the entire content of the Siebel database, use the database utilities provided by your RDBMS vendor.
  • If your source repository is customized use the Migrate option of the Database Configuration Wizard.

    For more information on migrating repositories, see Going Live with Siebel Business Applications.

NOTE:  When exporting a repository in a Windows or UNIX environment using the Export Repository option of the Database Configuration Wizard, the log files are placed in following directories:

  • SIEBSRVR_ROOT\log\exprep\output
  • SIEBSRVR_ROOT\log\exprep\state

NOTE:  The value "exprep" is the default process name for the exprep utility. You can change this value to facilitate ease of use.

For information on importing or exporting repositories, see To import a repository in a Windows environment or To import a repository in a UNIX environment depending on your operating system.

The importing procedures apply to both importing and exporting, although they present only the importing case. Exporting is similar, in that you identify the repository to export instead of the one to import.

When exporting a repository using the Database Configuration Wizard, all the values specified in the dialog boxes are written to the SIEBSRVR_ROOT\master_exprep.ucf file. After the parameters are collected, you are prompted to execute the export now or not. If you choose to not export now, you can execute the export later by running the following command in the command line:

siebupg.exe /m master_exprep.ucf

To import a repository in a Windows environment

  1. Stop all Siebel Servers by navigating to Start > Settings > Control Panel > Services.

    NOTE:  The Database Configuration Wizard runs in live mode only so you must be connected to the Gateway Name Server to run it. For further information on Siebel Configuration Wizard running modes, see the Siebel Installation Guide for the operating system you are using.

  2. Select Start > Programs > Siebel Enterprise Server Configuration 8.0 > Database Server configuration.

    The first screen of the Database Configuration Wizard appears.

  3. Enter the information you are prompted for in each screen, and click Next to continue.
  4. Select Import Repository when prompted for a database operation.
  5. Specify that you want to import the standard Siebel 8.x repository.
  6. When the Configuration is Complete screen appears, select one of the following options, and click Next:
    • Yes apply configuration changes now. The configuration information you entered is saved and you can choose to launch the Siebel Upgrade Wizard in Step 9.
    • No I will apply configuration changes later. The configuration information is saved but you can not choose to launch the Siebel Upgrade Wizard in Step 9.
  7. On the Configuration Parameter Review screen, review the configuration values you entered on the previous screens. To change any of the values, click Back to return to the screen with the parameter you need to change. If the values are correct, click Next to continue.
  8. You are prompted as to whether you want to execute the configuration:
    • Click No if you decide you do not want to continue with the upgrade process.The configuration information you have entered is not saved. You must enter the database configuration parameters again.
    • Click Yes to continue. The configuration information you have entered is saved.
  9. Depending on the option you selected in Step 6, do one of the following:
    • If you selected the No I will apply configuration changes later option, click OK to finish. The configuration information is saved in a master file located in SIEBEL_ROOT\bin but the Upgrade Wizard is not launched. You can restart the configuration and run the Upgrade Wizard later. For more information on the Upgrade Wizard, see the Siebel Database Upgrade Guide.
    • If you selected the Yes apply configuration changes now option in Step 6, the configuration information you entered is saved. Click OK and the Siebel Upgrade Wizard is launched; it calls the SQL generator to create or populate SQL scripts.

To export a repository in a Windows environment

  • Follow the same as procedure as for importing a repository, but select Export Repository in Step 4.

To import a repository in a UNIX environment

  1. Verify that the Siebel Server is stopped.

    NOTE:  The Database Configuration Wizard runs in live mode only so you must be connected to the Gateway Name Server to run it. For further information on Siebel Configuration Wizard running modes, see the Siebel Installation Guide for the operating system you are using.

  2. Make $SIEBEL_ROOT the current directory.
  3. Source environment variables:
    • Korn: . siebenv.sh
    • C shell: source siebenv.csh
  4. Review the values of the following environment variables and confirm the settings are correct:
    • SIEBEL_ROOT. This path must end in siebsrvr, for example /usr/siebel/siebsrvr.
    • LANGUAGE. This is the language in which the Database Configuration Wizard runs. The value of this variable is a language identifier string. For example, enu is the identifier string for English.

      If either $SIEBEL_ROOT or $LANGUAGE is not set or is incorrect, you must correct them before proceeding.

  5. Start the Database Configuration Wizard by running the following command:

    $SIEBEL_ROOT/bin/ssincfgw -args MODEL_FILE=$SIEBEL_ROOT/admin/dbsrvr.scm MODE=LIVE

    The first Database Configuration Wizard screen appears. Enter the information you are prompted for in this screen, and click Next to continue.

  6. Enter the information you are prompted for in all subsequent screens. Use the Next and Back button to navigate between screens.
  7. Select Import Repository when prompted for a database operation.
  8. Specify that you want to import the standard Siebel 8.x repository.
  9. After you have entered all the requested information, the wizard displays the following message:

    Configuration is complete: configuration parameters will be saved to <$Masterfile> file when the wizard completes. Please run the following command line after you exit from this configuration wizard. This command will deploy the process you configured to the database.

    $SIEBEL_ROOT/siebsrvr/bin/srvrupgwiz /m $SIEBEL_ROOT/siebsrvr/bin/<$Masterfile>

  10. Click Next to continue. The utility displays the Parameter Review screen listing all the values you have entered.
  11. To amend any of the configuration values, click Back to return to the appropriate screen and make changes. Otherwise, click Next.
  12. You are prompted as to whether or not you want to execute the configuration:
    • Click Yes, and the configuration information is saved in a master file located in $SIEBEL_ROOT/bin but the Upgrade Wizard is not launched. For more information on starting the Upgrade Wizard, see the Siebel Database Upgrade Guide.
    • Click No, and the configuration information you entered is not saved.

To export a repository in a UNIX environment

  • Follow the same as procedure as for importing a repository, but select Export Repository in Step 7.
  
Using Siebel Tools Copyright © 2007, Oracle. All rights reserved.