Author Topic: Migration of Audit and Content Database  (Read 663 times)

Offline Pranathi

  • Full Member
  • ***
  • Join Date: Feb 2019
  • Posts: 35
  • Forum Citizenship: +0/-0
Migration of Audit and Content Database
« 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

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 666
  • Forum Citizenship: +25/-1
Re: Migration of Audit and Content Database
« Reply #1 on: 02 Jul 2020 11:52:57 am »
Quote
the 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.

Offline Pranathi

  • Full Member
  • ***
  • Join Date: Feb 2019
  • Posts: 35
  • Forum Citizenship: +0/-0
Re: Migration of Audit and Content Database
« Reply #2 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.