This topic describes how to create a MySQL repository.
Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer. However, if you are unfamiliar with MySQL and DBMS systems in general, you might want to consider a suitable front end tool.
MySQL Administrator, available from http://dev.mysql.com/downloads/gui-tools/5.0.html, is one such tool. It provides a convenient graphical user interface to enable the creation of databases, execution of scripts, backups and restores.
To get started, follow the steps below:
- Run MySQL Administrator and create a new database.
- Run MySQL Query Browser, and open and execute the MySQL repository script.
- Below is an example showing the tables created in the MySQL repository after running the script in MySQL Query Browser.
MySQL repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you are using an existing .EAP model, you can upsize it.