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