Create a MySQL Repository

Return to Introduction  Previous page  Next page

Note: This feature is available in the Corporate edition only.

Before creating a MySQL data repository in Enterprise Architect, you must set up the MySQL and MySQL ODBC drivers. For further information on setting these up, see Setup a MySQL ODBC Driver.

To create a new MySQL repository, you must first create a database into which to import the table definitions for Enterprise Architect. Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script are up to you.

·Registered users can obtain the scripts from the Registered Corporate edition Resources page of the Sparx Systems website at
·Trial users can obtain the scripts from the Corporate edition Resources page of the Sparx Systems website at

Creating the Data Repository

Once you have created the database and executed the script, you should have an empty Enterprise Architect project to begin working with. You can transfer data from an existing .EAP file or simply start from scratch.

Third Party Tools

If you are unfamiliar with MySQL and DBMS systems in general, you might want to consider a suitable front end tool.

PremiumSoft Navicat (formerly PremiumSoft MySQLStudio) is one such tool, and is available at Navicat provides a convenient graphical user interface to enable the creation of databases, execution of scripts, backups, restores and more.

To get started with Navicat, follow the steps below:

1.Create a new database.
2.Open and execute the MySQL script.
3.Below is an example showing the tables created in the MySQL repository after running the script in Navicat.