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

[GeorgeMcGeachie]

I'm not familiar with SQL Server, so I'm not sure what you mean by extended properties, but here goes anyway .

Have you checked the PowerDesigner help topic?

     Data Modeling > DBMS Definition Reference > Microsoft SQL Server

For a SQL Server database, every Table and Column has an extra tab on the property sheet, called 'Microsoft', which is where you'll find properties that are specific to SQL Server. They will probably not appear on a diagram by default, though you could display them if you want to.

[Former Member]

Hello George,

Thank you for taking the time to answer 🙂

Sure, I have checked the Powerdesigner help topic you mention (and the vast majority of online ressources provided by SAP) without finding any clue of what's going wrong.

I have made sure to review the physical model after the reverse engineering is completed, and every tab in the table properties  (the Microsoft tab gives information about partitioned tables, filegroups, filestream and compression. No trace of table extended properties).

I have also reviewed the different database options and tabs available when you configure the reverse engineering process.

There's a chance I miss something, since I am an absolute beginner with PowerDesigner, but I can't say what.

For your information, you will find an example of SQL Server extended properties in the image below.

Thank you again for your answer, very appreciated 🙂

Thierry