Skip to main content

Creating a database for an Enterprise Architect model

  • Download the database script to create the necessary tables from https://sparxsystems.com/downloads/corp/scripts/EASchema_1220_MySQL.sql
  • Save the EASchema_1220_MySQL.sql file in the directory C:\EAInfoport\Dataprojekt
  • Start the (line) program MySQL 5.7 Command Line Client
  • Log in with the root (administrator) password
  • Create the database “ea” using the command CREATE DATABASE ea;
  • Switch to the database using the USE ea command;
  • Create the tables needed for Enterprise Architect to work with the command SOURCE C:\EAInfoport\Dataprojekt\EASchema_1220_MySQL.sql
  • End the program