Create a MySQL Repository

Creating a MySQL database is fully documented in the product information provided with your MySQL installer.

Having created your MySQL database, use the SQL script provided by Sparx Systems to create the required table definitions for Enterprise Architect.

You can obtain the scripts from the Sparx Systems website, on the:

• Registered Corporate edition 'Resources' page (Registered users)
• Corporate edition 'Resources' page (Trial users)

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 is one such tool, providing a convenient graphical user interface to enable the creation of databases, the execution of scripts, and backups and restores.

You might, therefore:

1. Run MySQL Administrator and create a new database, then
2. Run MySQL Query Browser, and open and execute the MySQL repository script

After creating a MySQL data repository in Enterprise Architect, you must set up the MySQL ODBC driver.

Learn more

• Create a project in a MySQL database
• Registered User's Scripts page
• Trial User's Scripts Page
• MySQL Workbench (including MySQL Administrator) download site
• Set up a MySQL ODBC Driver

Notes

• This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions
• Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic