I am in the process of developing a bteq script that captures ddl from dbc.tables for migration purposes. I'm creating a series of 'show table' entries into a file that is then executed to create the ddl. Does anyone know of a good way to also capture the table and column level comments to apply to a table when migrating from one environment to another?
Did you consider to use arcmain to migrate DDL's?
Beside this dbc.tables and dbc.columns contain the commentstring. So you should be able to generate the comment statements as well.