This forum post indicates there is no native support for extended properties. My specific interest is in SQL Server extended properties.https://www.sqlservercentral.com/Forums/Topic191115-9-1.aspx
Despite the post's age I see no indication this has changed (beyond MS_Description support). That same post says that a macro exists (pjs Retrieve Definitions From Extended Properties MSSQLServer) that adds such functionality. Unfortunately the macro link http://www.embarcadero.com/resources/ermacros.html is dead.
Does anyone know of a working link - or does someone have the code that they could post here?
Another path to an answer is if someone has a working example of issuing a query from an ER/Studio macro. I have many dozens of databases and manually exporting property data from each one and then manually importing it to the correct model is really an unacceptable solution but the aforementioned macro description says it uses ODBC to pull the data directly from a source database. I'm sure I could re-implement the support but I can't see a mechanism for issuing a command and processing results via ODBC from the macro language.
I don't have any macros that can issue queries against a database but if you were able to script it in a batch job then I can help get this to work. Macros can be run through the command line. What you could do is get the batch job to run a query against the database to create a csv file or something similar and then run the macro to add that information to the postsql of a specific data model. I can help with the macro piece but not the piece to query the database. I am investigating how to use macros to connect to a database.
Thanks for looking into this.Fortunately I don't need round-trip. The data is needed when we generate model documentation. It needs to contain the data in extended properties. Developers have their own tools and I import what they do into models.
I am checking with Karen who provided the original response in the old post you mentioned. I'll let you know if she is able to send me anything helpful.