When I needed to migrate our repository from Sybase to Oracle, I did so by:
1.) Instantiating a new repository on Oracle
2.) Used PowerCenter to copy the data from the old repository to the Oracle repository.
3.) Immediately changed the connections for the document and universe domains, since the values in the copied repository pointed back to Sybase, as documented in this Supervisor FAQ.
4.) Tested
In testing, I found that while I could import documents and universes, the documents and LOVs were “corrupted”. I opened a case with BusinessObjects, who eventually told me that they “did not support migrating the repository from one database type to another”.
5.) I then imported all universes from the new repository.
6.) I then copied all of my LOVs and documents from the old repository, into appropriate folders for the new repository. I then opened and checked them and re-exported documents and universes to the new repository. This was brute force, but it worked.
Since this is a Supervisor-related topic, I am moving this topic from Gneeral Discussion to Security and User Administration => Supervisor.
Anita Craig 
(BOB member since 2002-06-17)