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