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
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.