UML Modelling of SQL Server Designs

[Matt Thomas]

A few hours of searching and I can't find either:

• a comprehensive UML model example of SQL Server designs (ranging from table designs, views and queries right through to SSIS packages etc).
• a UML Profile for SQL Server design.

Any leads anybody? Could be of considerable use to many of us  

[Wowbagger]

If I understand you correctly, you may want to look at the "Data Model" diagram:

Add Diagram->Extended->Data Modeling

That allows you to define Tables, instances of Tables, and relationships between tables such as Foreign keys, and to have EA generate a Database Description Language file from them.

HTH

[Matt Thomas]

Thank you for your reply Wowbagger!

It helps in the sense I realise I need to make my query clearer. I am familiar with EA's adeptness at data modelling of tables, and also with its close integration with Visual Studio for forward and reverse engineering of table designs.

I want an example of the UML support for Enterprise level modelling of the broad collection of SQL Technologies, ideally with SQL Profile(s) covering SQL Server 2000 through to 2008. So the problem is how to depict in an Enterprise level design model the various SQL Server components and packages (e.g. SSIS) alongside other technologies, such as WebServices etc.

IHTH