Messages

1

General Board / Add DB column descriptions to diagram table element

« on: July 02, 2021, 11:41:13 pm »

I am trying to document an existing Oracle data model, and I want the descriptions for each column to appear on the visual of each table on my diagram.  Is there a way to do this? 

The comments for each column stored in the DB go into the NOTES attribute for each column on the table object in the EA project.  I see there are some ways to adjust the visual appearance of the table elements on the diagram, but couldn't find a way to expose the NOTES attribute of each column.

As an example I'm looking for something like this that the Oracle database diagram tool can do: 


I want do this in EA because a lot of the 300+ tables in the DB do not have descriptions populated.  I need to add more comments and be able to display them on diagrams for the various sections of the DB before I start a large migration and modernization project.

2

General Board / Database Builder for Azure SQL Database

« on: June 30, 2021, 11:54:38 pm »

I am trying to design a database for Azure SQL Database.  In EA, when I go to "Database Builder" and then click "Click for New Database", I am presented with a list of database model types, but for SQL Server the latest version on my list is "Basic SQL Server 2012 Model".

Do I need to install something to get more recent versions of SQL Server or Azure SQL Database to be available?  or is SQL Server 2012 "good enough" for modeling for Azure SQL Database?

I have Enterprise Architect 15.2.1558 installed. 

Thank you