Book a Demo

Author Topic: Any tool for converting class model to database model?  (Read 5217 times)

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Any tool for converting class model to database model?
« on: July 20, 2018, 03:49:49 am »
Do you know any feature or plugin that allows, given a class model (classes with attributes and relationships), convert it to a database model of classes (classes stereotyped as <<table>> with columns and foreign keys)?

We don't have a ERD model, but a simple class model.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Any tool for converting class model to database model?
« Reply #1 on: July 20, 2018, 05:13:15 am »
How about EA's DDL script?

And (IIRC) there's an add-in called DBMode which is probably worth a look.

q.
« Last Edit: July 20, 2018, 07:15:22 am by qwerty »

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: Any tool for converting class model to database model?
« Reply #2 on: July 20, 2018, 06:40:02 am »
Look at DDL Transformation built in to Sparx EA.
You can tweak the transformation if it doesn't suit you exact needs too.
http://www.sparxsystems.com/resources/mda/ddl_transformation.html
Happy to help
:)

Nizam

  • Prolab Moderator
  • EA User
  • *
  • Posts: 320
  • Karma: +15/-2
  • Model Sharing - Simplified
    • View Profile
    • Professional Model Collaboration
Re: Any tool for converting class model to database model?
« Reply #3 on: July 20, 2018, 02:36:33 pm »
Do you know any feature or plugin that allows, given a class model (classes with attributes and relationships), convert it to a database model of classes (classes stereotyped as <<table>> with columns and foreign keys)?

We don't have a ERD model, but a simple class model.

You can use DDL or write a script to stereotype the objects, attributes, and connectors