COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: nagendramsc5 on 27 Jan 2009 05:04:48 AM

Title: How change the connection from Development server to Testing server
Post by: nagendramsc5 on 27 Jan 2009 05:04:48 AM
Hi all,
      I have one doubt that how to change the connection from development server to testing server.
Actually I developed the report in development server its working fine now I want test in Testing server how can I do that if any body knows let me know
Thanks in advance
Title: Re: How change the connection from Development server to Testing server
Post by: blom0344 on 13 Feb 2009 08:21:48 AM
Two / three possibilties:

1. There is one Cognos instance, which means changing the properties of the sign-on of the connection (every time again
1b. Create an additional sign-on for the connection and point to the other server/database

2. There are 2 Cognos instances. This would require exporting the report(s) along with the package (as .zip) and importing them from deployment folder to the other instance..
Title: Re: How change the connection from Development server to Testing server
Post by: PJQ on 19 Apr 2009 08:53:07 PM
Another option:  Copy - Paste report.
This technique assumes working data source packages in Prod and Dev.

Open the report in Report Studio on Server 1.
Tools Menu - "Copy Report to Clipboard".

Open Report Studio with a new report on Server 2
Tools - "Open report from Clipboard".
Save As.