-
Notifications
You must be signed in to change notification settings - Fork 3
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
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.
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.