Migration Process Question

[kado]

Hello Gurus,

I am trying to find the best way to migrate packages/reports from DEV to PROD (TEST is simply a folder on PROD). We are ramping up a Teradata solution which doesn't allow databases on the same server (instance) to have the same names.

Ideally, I would have let's say a 'GDW' data source connection on DEV that points at the DEV_GDW tables and associated tables. Then in Prod we would have a 'GDW' data source connection that points at PROD_GDW and tables of the same name in DEV. So that way, we would simply use the Cognos migration tools and once a package using the 'GDW' data source arrives in PROD in automatically points at the PROD tables.

But since the databases on PROD have the a different name the pre-qualified SQL still points at DEV once promoted to PROD.

Any thoughts? Suggestions, recommendations?

thanks,
kado