This topic describes how to create an Oracle repository.
Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer.
Create the Repository
To create an Oracle repository, 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_EASchema.sql, which creates the tables and indexes for an Enterprise Architect project.
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 are using an existing .EAP model, you can upsize it.