COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Kavya on 02 Jul 2020 10:47:08 AM

Title: Migration of Audit and Content Database
Post by: Kavya on 02 Jul 2020 10:47:08 AM
Hello,

Can someone please advise what will be the pros and cons of migrating audit and content DB from one Database to another within Oracle?
Will we loose the reports/report properties/database connections/scheduled reports?
We are planning to migrate the audit and content DB from one host to another host. But the database will be the new one.

Current State:
Hostname: H1
DB: DB1
Schema: CS and AUD (content and Audit)

Future State:
Hostname: H2
DB: DB2
Schema: CS and AUD (content and Audit same as above)

Cognos version is 10.2.1 and Oracle DB version is 18c.
What should be the steps to follow?

Thanks,
Pranathi
Title: Re: Migration of Audit and Content Database
Post by: dougp on 02 Jul 2020 11:52:57 AM
Quotethe database will be the new one.
What does that mean?  Do you mean you will be creating an empty database to use for the content store and an empty database to use for audit?  If so, then yes, you lose everything.

To keep your content (reports, dashboards, etc.) you'll want to go into Cognos Administration and perform a deployment export of the entire content store.  Once the new database is in place and Cognos is configured to use it, you need to perform a deployment import.

Cognos does not provide a way to migrate audit data.  Talk to your DBAs about that.

For more information, read the docs.
Title: Re: Migration of Audit and Content Database
Post by: Kavya on 02 Jul 2020 02:59:10 PM
Thanks Dougp.

Export/Import of the complete Content store did work and I was able to get all the reports after successfully database migration.

Thank you again.