Cognos Controller - change database

[isap]

Hi all,
my company is in the process of switching from 1 version to another of sql db. Can someone point out the steps that need to be carried out. Do I need to run the dbconv utility which shud be all or more? Thanks a lot for any help......


Cheers

[Prerna Chaudhary]

Hi,

Please make sure that after migrating to new version of SQL Server,the DSNs of all the cognos reports  which are initially based on the previous version of SQL Server repoint to the new one.
So in short you will have to repoint the DSNs for all of your  projects to the new DB server.

Thanks and regards
Prerna
-------------------------------------------------------------------
pchaudhary@infocepts.com
-------------------------------------------------------------------

[isap]

Prerna- thanks for the info, I ll let the IT know about it.....do you have any links to a source or steps to implement your suggestion. Thanks in advance.


Cheers

[IBMrc]

Although this is a very old thread, if people are interested in this topic they can read my two Technotes on the subject:

   
• http://www-01.ibm.com/support/docview.wss?uid=swg21594174
• http://www-01.ibm.com/support/docview.wss?uid=swg21348028

:) Hopefully this is useful to someone :)