SQL Scripts Oracle 9i and 10g
Before you set up EA for use with Oracle, we recommend you run the Tools | Data Management | Data Integrity tool on the base project you wish to upsize to Oracle. 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 three stages to upsizing your database for Oracle. Follow them in order:
Stage One: Create an Empty Database
| 1. | Install Oracle. |
| 2. | Create an empty database. |
Note: See Create a New Oracle Repository.
Stage Two: Configure the Database
| 1. | Using a tool such as the SQL*Plus or SQL Plus Worksheet, load the Oracle_BaseModel.sql file. This is 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. |
| 2. | Make sure the new database is selected as the current database. |
| 3. | Run the script to create all required tables/indexes etc. |
Note: See Create a New Oracle Repository.
Stage Three: Transfer the Data
You now have an empty database - you can use the Project | Manage Data | Data Transfer menu option in EA to transfer an existing model into the server.
| 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: |
| 3. | Select .EAP to DBMS as the Data Transfer Type. |
| 4. | Enter the name of the .EAP file to upsize to Oracle 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 "Oracle Provider for OLE DB" from the list, then press Next. |
| 7. | On the Data Source details page of the connection dialog, enter database name and security details as required. |
Note: See Connect to an Oracle 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 Oracle and can now open it from EA.
