GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Objects

 Print  |  
Question:  How can we migrate BO 6.1 repository to a multi schema database?

Answer: We have three different repositories on different databases. No we want to move all the three to single database by creating three different schema's.


September 09, 2009 10:43:06 #1
 prakharrajsingh   Member Since: January 2007    Total Comments: 3 

RE: How can we migrate BO 6.1 repository to a multi schema database?
 
Though it is more of a DB migration centric question rather than BO repo migration.

It depends completely on which Db is being used and what would be the target DB.

in SQL Server you have to maintain seperate DBs for each of the 3 earlier schemas.

In Oracle, you can have all three under the same DB; only thing different would be they would under different schemas; and kept isolated using security and permissions in Oracle.

Cheers
     

 

Back To Question