SQL Scripts MySQL Instructions

Before you set up EA for use with MySQL, we recommend you run the Tools | Data Management | Data Integrity tool on the base project you wish to upsize to MySQL. This will ensure data is 'clean' before uploading.

Warning: Before proceeding, ensure MDAC 2.6 or 2.7 is installed on your system.

Upsizing Your Database

There are four stages to upsizing your database for MySQL. Follow them in order:

Stage One: Install MySQL Components

 

1. Install MySQL - version 4.0.3 or higher.
 
2. Install MySQL ODBC 3.51 or higher.

 

Note: The MySQL ODBC driver version 3.51.14 creates problems in incorporating tests in elements. Use a different version, such as 3.51.12.

 

3. Create a suitable ODBC Data Source to point to your new database.

 

Note: There are two critical non-default settings required; see Set up a MySQL ODBC Driver and ensure you select the checkboxes in step 7.

 

 

Stage Two: Select Table Type

 

1. If you wish to use InnoDB tables, set up the MySQL .ini file as required and run the MySQL - InnoDB BaseModel script.
 
2. If you wish to use MyISAM tables, set up the MySQL .ini file as required and run the MySQL - MyISAM BaseModel script.

Note: See discussion on MySQL limitations.

Note: The scripts are available to registered users on the Corporate Edition resources page of the Sparx website at http://www.sparxsystems.com/registered/reg_ea_corp_ed.html.

                       

 

Stage Three: Create the Database

 

1. Create an empty database.

 

Note: See Create a New MySQL Repository.        

 
2. Now that have an empty database you can use the Tools | Data Management | Data Transfer menu option in EA to transfer an existing model into the server.

 

 

Stage Four: Transfer the Data

 

1. Open EA (you can press Cancel at the Open Project screen to open with no project loaded).
2. From the Tools | Data Management submenu, select Data Transfer. This will open the Full Model Data Transfer dialog:

 

transferData

 

 

3. Select .EAP to DBMS as the Data Transfer Type.
4. Enter the name of the .EAP file to upsize to MySQL as the Source Model.
5. Press the Browse [...] button at the right of the Target Model field. This will open the Datalink Properties dialog.
 
6. Select "Microsoft OLE DB Provider for ODBC Drivers" from the list, then press Next.
       
7. Select the ODBC Data Source you configured to point to your new database.
       

Note: See Connect to a MySQL Data Repository for more information.

 

8. Press OK.
 
9. If desired, check the Logfile checkbox and enter a path for the data transfer log file.
                       
10. Press Transfer Data to begin the data transfer process.

 

 

Once the process is completed, you will have upsized your model to MySQL and can now open it from EA.