Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change the Repository

Status
Not open for further replies.

mssplr

MIS
Jul 12, 2001
2
0
0
US
My Repository currently resides in a SQL 7 Database. We are moving to Oracle 9i. Does anyone know of any problems that we will have changing our repository to a different database and how we would go about this?
 
you jsut need to covertyour datatypes.i seem to remember that your problem will be with the table which holds the documents. The best way to get around this is to import all documents create an empty doucment domain on oracle and export all documents, the rest of the repository is ok to convert.

Good Luck
 
Whenever the BusinessObjects repository is transferred, it involves not only changing the connection that BusinessObjects has with your database, but also changing the internal sub-connections that exist within the repository between the Security, Universe, and Document domains.

This modification can only be performed when the server will be used with a database which is of the same brand as the previous database. For example, Oracle to Oracle or Sybase to Sybase. Business Objects does not support any other manual manipulation of repository tables!

The Safe Recovery operation is described in detail in the Supervisor's Guide for BusinessObjects (found on the BusinessObjects CD: "/ Manuals / English / Supervisor50EN.pdf." fot BO 5.x).

The Safe Recovery operation involves re-building the BOMain.key. If the BOMain.key is shared by many clients, you will need to re-distribute the file after moving the Repository.

The main steps for this procedure include:

1. Create a database dump file and install it on the new server.
2. Perform a Safe Recovery (see above notes).
3. Login to the Supervisor Module.
4. Go to the Tools menu and select 'Repository.'
5. Select the Universe domain and click 'Modify'
6. Using the Domain Modification Wizard, setup the network layer to point to the location of the new Universe domain tables.
7. Test the new connections to each domain with the Test button.
8. Repeat steps 4-6 for each domain as necessary. (For example, if your Document domain exists on a different server, you will need to update the connection via the network layer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top