Data Modeling Data Types

Enterprise Architect supports modeling and reverse engineering of database schema for these DBMS products:

DB2
Firebird/InterBase*
Informix
Ingres
MS Access 97, 2000, 2003
Access 2007
MS SQL Server 2000, 2005, 2008
MySQL
SQLite
Oracle 9i, 10g and 11g
PostgreSQL
Sybase Adaptive Server Anywhere (Sybase ASA)
Sybase Adaptive Server Enterprise (Sybase ASE)

With the current release, details for modeling the above are included in the EAbase.eap repository available in the directory where Enterprise Architect is installed. This is the base repository used for creating new repositories.

Where you have an existing repository that was created prior to a DBMS data type being supported, you can use one of the following scripts to update the support for the DBMS data types:

For more information on importing these downloaded XML script files, please see: Import Reference Data.

Note: A script will only update the repository that it is applied to. If the EAbase.eap is not up to date, it is best to apply the script to this base repository.