Going Live with Siebel Business Applications > Migrating Repositories Between Databases >

Preparing the Target Database for the New Repository


This topic describes the task of preparing the target database for the new repository. This task is a part of the Process for Migrating Repositories. For background information on migrating repositories, see About Migrating Repositories Between Databases.

Complete the following actions before you migrate the repository to the target database:

  • Make sure that all mobile users perform a full synchronization to avoid any unexpected issues in the target environment as a result of database schema changes made to the new repository.
  • The target enterprise can be online for a portion of the repository migration procedure. (For more information on this feature, see Preparing for Target Environment Status Selection.) However, if you do not select this option, stop all Siebel Server tasks and disconnect all database access until migration has been successfully executed.

    NOTE:  All connected users (including the database administrator) must disconnect at one point during the running of the repository migration configuration utility.

  • Do a full backup of the target database after all mobile user transactions have been merged.
  • Make sure that the target database configuration meets the database requirements outlined in the Siebel Installation Guide for the operating system you are using.
  • Do not change ODBC parameters or settings for datasources created by the Siebel Server installation.
  • Verify the names of all repositories in the target database.

    You will later choose a new name that the repository being migrated will have in the target database. It is recommended that you keep the name of your target repository constant. Accordingly, rename the existing target repository to show that it has been superseded. You will also later import a repository, to which you should give the standard name for your target repository. For further information on repository naming guidelines, see Using Siebel Tools.

  • Update database statistics if warranted for your database.
  • Delete older repositories from the target database. This procedure may run for some time. For further information on this task, see Using Siebel Tools.

NOTE:  The repository migration process references two ODBC data sources. One is the source database and the other is the target database. When running the migration task from the source system, it is necessary to create an ODBC data source for the target database manually. This applies to all server and database platforms. For further information on verifying the ODBC data source, see the Siebel Installation Guide for the operating system you are using.

Going Live with Siebel Business Applications