If you are unable to create a new account, please email support@bspsoftware.com

 

I want to migrate single datasource from one environment to other.

Started by monica, 22 Apr 2012 02:50:15 AM

Previous topic - Next topic

monica

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.

simon.hodgkiss

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