What?

---

The MOLA::UMLtoDB tool is the simplest way to create your database schemas!. It automatically generates a SQL DDL script to create the database corresponding to the input UML class diagram, including:

• Dropping of existing database elements
• Creation of tables and columns
• Management of taxonomies(three alternatives: only subtypes, only supertypes, both)
• Creation of primary keys, unique keys and foreign keys with on update and on delete policies
• Support for auto-increment primary keys (by generating autoincrement fields or SEQUENCE-like constructs plus Triggers)
• Selection of the most appropriate database type for each column depending on the UML datatypes
• Support for enumerations (either by using an ENUM type or by using a VARCHAR field plus a CHECK constraint)

All major database vendors are supported: Oracle, MySQL, Postgresql, DB2, SQLServer, Firebird, Interbase, VoltDB*.

Why?

---

The two main qualities of this tool are its simplicity (i.e. the input is a simple UML class diagram, no stereotypes or profiles nor other kinds of annotations are needed) and the quality of the SQL sentences it generates. Thanks to this, you can save a lot of time in your development process by avoiding an error-prone and time-consuming manual generation of this very important part of your application.

Some of the benefits of this tool are the following:

• Boost your productivity by using the UML models to automatically generate your database
• No need to learn new modeling constructs/stereotypes. Just basic UML class diagrams.
• No installation required (see below)
• Use your favourite UML CASE tool to specify the input model (if not currently supported please contact us
• Forget about debugging and testing the scripts and save time
• The scripts are already commented for you
• All this for a small subscription fee.

How?

---

This tool is implemented as a service (SaaS). Simply upload the xmi file storing your UML class diagram, (optionally) indicate configuration parameters for the generation and, you will get as a result a text file with all the SQL sentences needed to immediatelly create your complete database!. The XMI model and the SQL script are removed after the generation, so you do not need to worry about the confidentiality of your designs

DATABASE SCHEMA GENERATION IN TWO STEPS

Step 1: Provide input UML model
Enter the input UML file and choose the database management system you want to generate the schema for

Step 2: Configure the generation
Indicate the configuration options to be used during the generation process

and just like that, the resulting SQL DDL file is ready for download!!

YOU CAN ALSO SEE THE SERVICE RUNNING IN THIS VIDEO

Examples

---

Let's see an example of a SQL DDL script generated by this service. Given the following UML model (represented, for instance, by this ArgoUML 0.24 XMI file )

the service will generate this SQL script for MySQL v.5 (results may vary depending on the configuration options chosen during the generation). Thanks to the included comments, the script is self-explanatory

Personalize!

---

We also offer the possibility of creating your own personalized database generator. Explain us your requirements and we will provide you with an adapted version of our generator perfectly suited for the specific needs of your development team. This will help you to maximize the productivity of your team and the quality of your code.

How much?

---

A limited version of the service is available at no cost

The professional version of the service requires a small monthly subscription fee ( only 9€ / 12$ ) Pay only the months you need the service or opt for a cheaper yearly fee (discount in the yearly fee is equivalent to two free months of the service!). No automatic renewal of the subscription so you don't need to worry about undesired payments. Exceptions for class use in universities and NGOs will be considered.

Comparing both versions

Feature	Professional	Free
Creation of tables
Creation of Primary, Unique and Foreign Keys
Management of class hierarchies
Support for auto-increment PKs
Generation of DROP sentences
Generation of indexes
Ad-free
Priority email support
Maximum model size	Unlimited	5 classes

Supported languages

---

Currently, this service supports the English, Spanish and Catalan languages (both for the interface and for the comments in the generated SQL DDL file). The language used depends on the client browser configuration.

Run the service!

---

Three simple steps:

1. Register as a user of the portal (top right column)
2. Accept the terms and conditions
3. (Optional) Purchase a subscription to upgrade to the professional version of the service (your account will be automatically upgraded just after purchasing the subscription)

   1 MONTH access
   1 YEAR access

4. Launch the service!

I want to know more

---

Contact us, subscribe to the portal feeds or to the portal news mailing list for announcements

*Company logos are trademarks of their respective owners