Create a Project in a MySQL Database

To create a project in a repository on MySQL 5, you work through these stages:

Stage 1: Create an empty database repository and set up the data tables

Stage 2: Set up the ODBC Driver

Stage 3: Perform a project integrity check on the project file you are using as a base (optional, but recommended)

Stage 4: Transfer the data

Stage 5: Connect to the repository and open the project

Prerequisites

A machine with MySQL version 5 or higher installed and running,

MySQL ODBC - either 5.1.5, or higher than 5.2.4 (other versions are not recommended)

Create a MySQL Repository

MySQL supports two different storage engines - InnoDB and MyISAM. In older versions of MySQL MyISAM was the default storage engine, but from MySQL v5.5 onwards InnoDB is the default. As of Enterprise Architect v13, Sparx Systems will no longer provide updates to the MyISAM script and recommend all users to choose InnoDB, as it supports transactions and UTF8.

Step

Action

See also

1

Create a new empty database and configure it to your installation's defaults.