Oracle Server Repository
Note: |
This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions. |
Before creating an Oracle data repository, you must have the appropriate version of Oracle (9i, 10g or 11g) and MDAC 2.6 or higher installed, and access permission to create a new database. Please note that setting up Oracle and the issues involved are beyond the scope of this manual. Consult your program documentation for guidance.
Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script are up to you.
- Registered users can obtain the scripts from the Registered Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/registered/reg_ea_oracle_instructions.html
- Trial users can obtain the scripts from the Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/resources/corporate/.
Create the Data Repository
Oracle repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you want to use an existing .EAP model, you can upsize it; follow the steps below:
- Create a new database on the Oracle server.
- Connect to the newly created database with a program such as Oracle SQL*Plus or SQL Plus Worksheet.
- Execute the script Oracle_BaseModel.sql, which creates the base model tables and indexes for an Enterprise Architect Project.
