COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: monica on 22 Apr 2012 02:50:15 AM

Title: I want to migrate single datasource from one environment to other.
Post by: monica on 22 Apr 2012 02:50:15 AM
Hi Gurus,

I want to migrate single datasource from one environment to other.
I am currently creating a new data source connection when i migrate a package .
Please suggest.

Thanks in advance.
Title: Re: I want to migrate single datasource from one environment to other.
Post by: simon.hodgkiss on 23 Apr 2012 11:02:17 AM
Hi Monica,

you can export\import all data source connections from\to an environment as one of the options within the export\import task.  You can also choose to include signons from the source environment in your task if desired.

There isn't a way to specify export\import of one data source connection and exclude others as far as I'm aware in Cognos BI Server.  If your datasource connection exists in source but not in target, you could perform an import of data source connections with a conflict resolution of "Keep existing entries",  but I wouldn't recommend it.

I personally prefer to create the data source connection in the target environment manually, as it sounds like you have been doing.  I think this carries less risk than importing (and potentially overwriting) all data source connections from eg. your authoring environment to your production environment.

All the best

Simon
Title: Re: I want to migrate single datasource from one environment to other.
Post by: monica on 25 Apr 2012 01:35:43 AM
Hi Simon,

Thanks for  the info.