All Forums Database
goldminer 118 posts Joined 05/09
14 Aug 2012
Add comment when migrating a table

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?

 

Thanks,

Joe

ulrich 816 posts Joined 09/09
14 Aug 2012

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.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.