If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Migration of Audit and Content Database

Started by Kavya, 02 Jul 2020 10:47:08 AM

Previous topic - Next topic

Kavya

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

dougp

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.

Kavya

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.