Cameo Data Modeler provides code engineering capabilities, database script generation, and reverse engineering. A database model can be generated in the DDL script, which can then be run on the database engine to create database structures. Conversely, the database engine can export database structures into the DDL script, which can then be reverse-engineered into the database model. In addition, Cameo Data Modeler enables reverse engineering directly from a live database through the JDBC connection.
Cameo Data Modeler code engineering supports the following database dialects for script generation and reversing:
- Standard SQL
- Oracle
- MS SQL Server
- DB2
- MySQL
- PostgreSQL
- Sybase
- Pervasive
- Cloudscape / Derby
- MS Access
- Pointbase
As mentioned earlier, database modeling was significantly extended in version v17.0.1. However, database code engineering stayed at the same level as before. Currently, not all database concepts that can be modeled can be subsequently generated or reverse engineered. This situation will be amended in the future.