Copy 6.5 Repository to Oracle

[system]

We have been asked to copy our current Business Objects 6.5 repository database from UDB to Oracle. Is there a White Paper describing this process? Any other recommended resources on this topic for us?

thanks,
Penny

---

pbowman (BOB member since 2003-10-21)

[system]

@pbowman

We have been asked to copy our current Business Objects 6.5 repository database from UDB to Oracle.

Copy?
you want the repository to be moved to a new database in Oracle.
As we do in upgradation I think

1. Tou need to create the repository in Oracle
   2)Publish the universes and reports to the new repository

also please check:I remember we have a component in 6.5 for carrying out this task.

regards

[Moderator Edit: Duplicate post which was made 24 minutes later – deleted.]

---

BO student (BOB member since 2004-10-03)

[system]

I would suggest you should create a new 6.5 repository in Oracle and migrate All the USERS, Universes, and Reports.

Follow these steps:
a) Create a new 6.5 repository
b) Export all the users from UDB in a text file, Import in 6.5 oracle rep using Supervisor.
c) Save Universes for all users first, and export it to 6.5 oracle rep
d) Save reports and export it to 6.5 oracle rep

The New BOMAIN key has to be on all your WEBI servers, BCA servers and all FC machines.

If your total # of reports are more, then you can search for a utility in this forum, where you can keep all your reports in a directory and run that utility, it will transfer all your reports to Corp rep 6.5 oracle.

Hope this helps.

---

BO_Chief (BOB member since 2004-06-06)

[system]

You might also want to check out this topic:

FAQ: Supervisor

Moving a repository is fairly simple and straight forward, but you [i:75ec892836]do[/i:75ec892836] need to make sure that you follow all the steps. It is recommended that you disable access to the repository before doing this. You can use a Timestamp for this purpose. :arrow: First of all, [b:75ec892836]copy[/b:75ec892836] your repository database to its new location. :arrow: Open Supervisor, and on the Login screen, click on the Admin button, and follow the wizard to do a Safe Recovery. Thi…

Moving a repository is fairly straightforward if you are methodical and organized.

Good luck,
Judy

---

JMulders (BOB member since 2002-06-20)

[system]

@JMulders

You might also want to check out this topic:

FAQ: Supervisor

Moving a repository is fairly straightforward if you are methodical and organized.

Good luck,
Judy

Hi Judy,

The link given decsribes way to transfer repository.
But is it possible across the databases?.. here the discussion is
the repsoirory to be moved from UDB to Oracle.

Thanks

---

BO student (BOB member since 2004-10-03)

[system]

Raju,

Yes, it’s possible to go across databases like that. I had to move a repository once from Sybase to Oracle. I had the DBA dump the contents of the tables in Sybase, and load the contents into the Oracle database. It worked well.

---

MichaelWelter (BOB member since 2002-08-08)

[system]

Thank you for all the advice.

Penny

---

pbowman (BOB member since 2003-10-21)

[system]

@Raju Kacham

@JMulders

You might also want to check out this topic:

FAQ: Supervisor

Moving a repository is fairly straightforward if you are methodical and organized.

Good luck,
Judy

Hi Judy,

The link given decsribes way to transfer repository.
But is it possible across the databases?.. here the discussion is
the repsoirory to be moved from UDB to Oracle.

Thanks

Hi,

Yes, even if you are moving across DBMS types, as long as you have the proper SQL statements to insert rows into the new database, you would just follow the same steps.

The repository is just a database.

Judy

---

JMulders (BOB member since 2002-06-20)