EA Enterprise Architecture Upsize to MySQL
来源:互联网 发布:多益网络ipo 编辑:程序博客网 时间:2024/06/06 00:30
Upsize to MySQL
You upsize your model repository to a MySQL database in the following stages:
Stage One: Install MySQL Components
- Install MySQL version 4.0.3 or higher.
- Install MySQL ODBC 3.51 or higher.
- Create a suitable ODBC Data Source to point to your new database.
Note:
There are two critical non-default settings required; see theSet up a MySQL ODBC Driver topic and ensure you select the checkboxes as directed in step 7 of that procedure.
Stage Two: Select Table Type
- If you are using InnoDB tables, set up theMySQL .ini file as required and run theMySQL_InnoDB_EASchema.sql script.
- If you are using MyISAM tables, set up theMySQL .ini file as required and run theMySQL_MyISAM_EASchema.sql script.
Note:
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 Systems provides a suitable script to create InnoDB based repository tables, as well as the more common MyISAM. These are available from theSparx Systems website.
Stage Three: Create the Repository
- Create an empty repository.
You now can transfer an existing model into the MySQL repository as described below.
Stage Four: Perform Integrity Check
Run the project integrity check tool (select theTools | Data Management |Project Integrity Check menu option) on the base project that you intend to upsize to the MySQL repository, to ensure the project data is 'clean' before uploading.
Stage Five: Transfer the Data
- Open Enterprise Architect and select theTools | Data Management | Project Transfer menu option. TheProject Transfer dialog displays.
- In the Transfer Type panel, select the.EAP to DBMS radio button.
- In the Source Project field, type the name of the .EAP file to upsize to MySQL.
- At the right of the Target Project field, click on the[ ... ] (Browse) button. TheData Link Properties dialog displays, showing theProvider tab.
- Select Microsoft OLE DB Provider for ODBC Drivers from the list, then click on theNext>> button. TheConnection tab displays.
- Click on the Use data source name radio button and on the drop-down arrow, and select the ODBC Data Source you configured to point to your new database. In the setup example the driver title is Changes.
- If required, type a User name andPassword.
- If required, in the Enter an initial catalog to use field type an initial catalog.
- Click on the Test Connection button to confirm that the details are correct.
- If the test does not succeed, revise your settings. If the test succeeds, click on theOK button. The Project Transfer dialog redisplays.
- If required, select the Logfile checkbox and type a path and filename for the data transfer log file.
- Click on the Transfer button to begin the data transfer process.
Once this process is complete, the content of the .EAP model exists on the MySQL repository and you can nowopen the repository from Enterprise Architect.
Note:
You cannot transfer a source .EAP file that was created using a version of Enterprise Architect earlier than 3.5.0.
- EA Enterprise Architecture Upsize to MySQL
- Doing Enterprise Architecture- EA Key Success Factors
- EA(enterprise architecture)中的UML反向工程
- The Practical Guide to Enterprise Architecture
- Dynamic Enterprise Architecture: How to Make It Work
- Model Driven Architecture: Applying MDA to Enterprise Computing
- 初识EA(Enterprise Architect)
- 初识EA(Enterprise Architect)
- Enterprise Service Architecture
- Enterprise Architecture 简介
- SAP Enterprise Architecture Framework
- Zachman Enterprise Architecture
- Enterprise Architecture Bibliography
- enterprise architecture注册码
- 安装UML工具:EA(Enterprise Architect)+首次使用EA
- Enterprise Architecture A to Z: Frameworks, Business Process Modeling, SOA, and Infrastructure Techn
- Enterprise Architect 7.0入门教程 EA 教程
- EA(Enterprise Architect) UML工具
- tab手势跳转activity
- 关于nginx中upstream机制的思考
- C语言之取整运算
- 摄影基础1 : 135相机
- 智能方便 Word 2013粘贴内容可预览
- EA Enterprise Architecture Upsize to MySQL
- CLisp 31:调用C程序之外部函数
- 里氏替换原则
- ADO数据库编程详解(C++)----初级入门篇
- Android display架构分析-SW架构分析(1-4) .
- 编程方法学——观后笔记【1】
- 集群式自动化测试框架(平台)设计与实现
- PB DataWindow 38个技巧
- 眼睛护理