Can anyone confirm that ER Studio doesn''t include SQL extended properties in reverse engineering a database?

Question

Post reply

Can anyone confirm that ER Studio doesn''t include SQL extended properties in reverse engineering a database?

Raymond-122342

SSC-Addicted

Points: 457
More actions
June 15, 2005 at 7:47 pm

#164681

I am using Embarcaredo ER Studio 6.0, and I am trying to reverse engineering a database to create diagram and data dictionary. I don't seem to be able to include SQL Server Extended properties, such as the column description that I entered in Enterprise Manager ( or Query Analyzer) in the data dictionary. Can someone confirm that ER Studio doesn't have that function for sure? I am new to ER Studio. thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Karen Lopez SSC Enthusiast Points: 199 More actions · Answer 1

ER/Studio can't do this natively, but there are macros on their website for doing just this.

http://www.embarcadero.com/resources/ermacros.html

SQL Server Extended Properties

This macro and associated stored procedure will allow you to "round-trip" definitions in SQL Server. The macro will convert the entity and attribute definitions to extended properties and insert them into the PostSQL of each table. These can then be generated to the database using the Generate DDL wizard. The stored procedure and batch file can then be used to extract the extended properties from the database into a spread sheet that can be imported using the "Import Object Definitions and Note from Excel" macro. This macro is courtesy of Earl Longoria.

pjs Retrieve Definitions From Extended Properties MSSQLServer

This macro provides a way to get Extended Properties directly from a SQL Server 2000 database. Provided you have an ODBC datasource configured and the required stored procedures in the database (see header of macro text), this macro will connect directly to the database and bring the extended properties into the model. This macro is courtesy of Paul Shapiro.

Just about anything can be done with Macros. We also allow macro exchanging on our ER/Studio User discussion group at http://www.infoadvisors.com/userlists.htm.

Karen