Creating warehouse upgrade scripts

Tools & Utilities

Creating warehouse upgrade scripts

Does anyone know of any tools that assist in upgrading downgrading schemas.

Overtime new tables are added , coloums added/removed etc. Is there a way to generate a scripts to take a warehouse from version x to version y of the schema?

Thanks in advance


Re: Creating warehouse upgrade scripts


I think  versioning tools like VSS, PVCS,SVN, CVS etc will do since you do check in and check out and you can compare easily. You can deploy. I wrote the end to end code promotion for a project in Ab Initio in unix.

If you don't want or have these then, I feel you have to write scripts. Writing scripts is fun and painful :). You  have to design  properly to suit your requirement. It may be a combination of unix scripts and Teradata scripts.