Changing Schema name for the Tables used

[cogprog]

Hi,
I have two schemas develepement(dev) and production(prod)I am creating catalogs on top of dev schema. prod is exact replica of dev. I need to point all my tables used in my catalog from dev to prod. Please suggest the way to accomplish it.

Cogprog.

 

[griffindm]

What is your RDBMS? For most platforms, all you have to do is rename the schema level in the catalog.

i.e.

Old: logicalDBName...
dev...
table01...
table02...
table03...
Changed to:

logicalDBName...
prod...
table01...
table02...
table03...

How you make this change in the catalog depends on your RDBMS platform. Let me know what your platform is and I'll
get back to you.

Hope this helps,

Dave Griffin

The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[cogprog]

Dave,
I am using Teradata. I have tried your solution and it works fine.
Thanks
cogprog