COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: rprimo on 18 Jan 2012 07:51:05 AM

Title: Upgrading from 10.1 FP1 to 10.1.1 database question
Post by: rprimo on 18 Jan 2012 07:51:05 AM
Hi everyone

Quick question regarding this install: is it ok to connect my fresh 10.1.1 install to my existing 10.1 FP1 content store?

I know it's probably not best practice, but we do not have room on our Oracle system to backup the existing database and use that instead.

Thanks!!

Ryan
Title: Re: Upgrading from 10.1 FP1 to 10.1.1 database question
Post by: tjohnson3050 on 18 Jan 2012 09:39:09 AM
It would be better to do a full content store export from Cognos Administration (out to a zip file), then start your new 10.1.1 install with a clean content store, then import the content using Cognos Administration.
Title: Re: Upgrading from 10.1 FP1 to 10.1.1 database question
Post by: rprimo on 18 Jan 2012 10:20:33 AM
Thanks for your reply.

Unfortunately I don't have that option.  Trying  more to ask if it's possible to do it this other way because that option isn't available to me.

Thanks!

Ryan
Title: Re: Upgrading from 10.1 FP1 to 10.1.1 database question
Post by: tjohnson3050 on 18 Jan 2012 10:47:13 AM
It's possible, but extremely risky.  I would never do it that way unless I had a test environment, and didn't care if it ever worked.  The risk involved in trying to use the old db is that if IBM has changed the schema of the content store in any way, your environment could be trashed.

If the problem is just space, then export the entire content store, delete the old content db, have the new blank db created.  When you start the services on your 10.1.1 environment, the new (correct) schema will be created.  Then import the content from the content export you performed.
Title: Re: Upgrading from 10.1 FP1 to 10.1.1 database question
Post by: rprimo on 18 Jan 2012 11:01:38 AM
Thanks again :)

Choked to say, but I don't have a test environment!  We only have live unfortunately so that isn't so feasible for me to do without wrecking the existing environment.

Sincerely appreciate your help, will have to see what I can do with the environment and resources that I have.

Ryan
Title: Re: Upgrading from 10.1 FP1 to 10.1.1 database question
Post by: tjohnson3050 on 18 Jan 2012 01:14:55 PM
No problem, good luck with it however you decide to do it.  Also be sure to read the release notes for 10.1.1 in the IBM Cognos information center:

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.cbi.doc%2Fwelcome.html