Context

You have an existing application which uses a database, and you want to modernize this application.

Solution

  • Reverse the existing database’s SQL schema to a table model. To do this, use the "4 Reverse SQL schema" command.

  • Transform the table model into a data model using the "2 Transform Table Model into Data Model" command.

  • Modify the data model in accordance with the requirements of the new application.

  • Generate the persistence model’s Java classes and the associated Hibernate mapping files using the "5 Hibernate & Java Generation" command.

  • Transform the data model into an SQL table model using the "3 Transform Data Model into Table Model" command.

  • Generate the SQL database script from this table model using the "6 Generate SQL script" command.