MySQL Limitations
Note that use of MySQL has the following limitations:
| 1. | If MyISAM table types are used (default), transactional support is disabled. To enable transactions you must set up MySQL to use InnoDB tables and create the database tables as InnoDB type. Sparx provide a suitable script to create InnoDB based repository tables, as well as the more common MyISAM. These are available to registered users on the Corporate edition Resources page of the Sparx website at www.sparxsystems.com/registered/reg_ea_corp_ed.html. |
| 2. | Due to limitations of the SQL query engine, some advanced search capabilities in the Search dialog are disabled. |
| 3. | Only MySQL 4.0.10 or later is supported. |
| 4. | MySQL ODBC Driver 3.50 or higher is required. This is the development version, but again the earlier version does not provide sufficient support to run Enterprise Architect. |
SQL Scripts
Sparx Systems provide various SQL scripts to assist with creating data repositories. These are available to registered users on the Corporate edition Resources page of the Sparx website at www.sparxsystems.com/registered/reg_ea_corp_ed.html.
