Skip to Content
Sep 07, 2018 at 01:16 PM

How to load table COMMENTs from a spreadsheet or csv into tables already within PowerDesigner


I have a spreadsheet containing two columns: Table name, and Comment

I want to bring these into an existing physical model, where the Comment gets populated into the 'Description' property of each table.

Is this possible, and how?

The reason I need this is that there is a bug in PowerDesigner preventing the 'COMMENT' value in a MySQL DDL script from being imported in to 'Description' when updating a model from a DB script. They have raised a KPI for this but might take sometime to get addressed. (