Initialize Database

Enterprise Architect supports various databases. The SQL scripts for initializing the databases can be found on a separate page. Hints for setting up the databases can be found in the documentation. Basically, you have to do the following steps

• Import SQL script that initializes the database schema
• Setup ODBC connection (MySQL example)
• Connect via ODBC (MySQL example)
• Import the EABase.eap project

EABase.eap

We encountered a problem that prohibits importing the base project into the database when running as restricted user. Enterprise Architect states that it cannot read the file. As a workaround, you can just copy the file from the program files folder into another folder and import the file from this location.

MySQL

We encountered an error initializing a MySQL 5.7.12 server because the default value for DATETIME attributes is 0000-00-00 00:00:00 in the intialization script. The internal representation of dates starts, however, in 1970. Therefore, you have to replace all occurrences of this default value with 1970-01-01 00:00:00.