COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: cognoslearner1 on 01 Aug 2017 09:15:48 PM

Title: Cognos content store migration
Post by: cognoslearner1 on 01 Aug 2017 09:15:48 PM
Hi All,

We are in a process to migrate Cognos content store schema to a different database. We are planning to migrate following below steps :

1. Stop Cognos services.
2. DBA will export the Cognos content store Schema and import in the new database.
3. Cognos configuration will be pointed to new database content store schema.
4.Start Cognos services.

We are using CS Oracle 11.0.2 now and will be moving to EXADATA oracle 11.0.2
Kindly let me know whether this would work ?

Right now we are connecting Cognos content store with database type is choosen as oracle
When pointing to new database where CS is imported we will be pointing CS with database type as Oracle Advanced .

Thanks,
Cognoslearner1
Title: Re: Cognos content store migration
Post by: bensah on 18 Aug 2017 03:39:50 AM
I think, this should work. Please take the content store backup from front end. If due to any reason if you face problem then you can reimport all content and it should work.

Thanks,
Benu