MySQL Repository
Note: |
This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions. |
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 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 http://www.sparxsystems.com/registered/reg_ea_corp_ed.html
- Trial users can obtain the scripts from the Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/resources/corporate/.
Create 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.
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.
