Reverse Engineering PowerDesigner 16.5 - SQLServer 2012 tables Extended Properties

[#1]

Hello all,

Sorry in advance if this basic question has already been asked. I have had a look at the forums first, as well as the documentation, without finding the answer I am looking for.

I am new to PowerDesigner 16.5, currently testing the reverse engineering function with a SQL Server 2012 database

I am trying to find how to import the table extended properties that were applied to the sql server tables (sp_addextendedproperties)

If it has already been imported with the reverse engineering default options, I can't see it anywhere in the resulting diagram.

Thank you in advance for your help

[Former Member]

Hi Thierry

When you open a table in your reversed model, have you clicked the "more>>" button

on the down/left side of the tableproperties-window ?

You should see then see  a tab with the Extended properties

can make a prinscreen now because i have only PD Reader here, but i used These Features a year or so ago and it worked fine

HTH

DJ

[Former Member]

Hi Dirk,

thank you for your answer 🙂

Very interesting. Checking the table properties after reverse engineering is the first thing I have checked, but I have not seen any 'extended properties' tab, which may suggest that they were not imported during the process.

Another explanation could be that the version of PowerDesigner I'm using (PowerAMC, the PowerDesigner's french version) does not support that feature. To be honest, I would be more than surprised if it were the case.

For your information, you will find below a screen capture of what I'm seeing (in french). No trace of 'Propriétés étendues' (extended properties)

Thank you again for your answer 🙂

Thierry