ENTERPRISE ARCHITECT

Data Modeling Data Types

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

• DB2
• Firebird
• MS Access 97, 2000, 2003, 2007, 2013
• MS SQL Server 2000, 2005, 2008, 2012, 2016, 2017
• MySQL v4, v5
• Oracle 9i, 10g, 11g, 12c, 19c
• PostgreSQL
• SQLite
• Informix (#)
• Ingres (#)
• InterBase (#)
• 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:

• SQL Server 2005
• SQL Server 2008
• Informix
• MS Access 2007
• SQLite
• Oracle
• Sybase SQL Anywhere (ASA)
• PostgreSQL / PostGIS
• DB2

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.

(#): No further development will be undertaken on these DBMS's, due to a general lack of interest for these products from the Enterprise Architect user base. Which will allow Sparx Systems to concentrate its efforts on the other areas of Database modeling.

See also: Supported Databases.