Create a Project in an Oracle Database

1

Create the empty database.

2

Using a tool such as Oracle SQL *Plus, load the Oracle_EASchema.sql file.

3

Run the script to create all required data structures.

1

Create a suitable ODBC Data Source to point to your new database.

1

Open the file-based project or template.

2

Select and run 'Project | Data Management | Project Integrity Check'.

This ensures your project data is 'clean' before uploading.

1

Open Enterprise Architect.

(If the 'Open Project' dialog displays, click on the Cancel button to open with no project loaded.)

2

Select the 'Project | Data Management | Project Transfer' menu option.

The 'Project Transfer' dialog displays.

3

In the 'Transfer Type' panel, select '.EAP to DBMS'.

4

In the 'Source Project' field, type the name of the project file to copy to Oracle.

If the .EAP file has Replication enabled, this must be removed before performing the transfer.

5

At the right of the 'Target Project' field, click on the button.

The 'Datalink Properties' dialog displays.

6

Select 'Oracle Provider for OLE DB' from the list.

Click on the Next button.

7

On the 'Connection' page of the 'Datalink Properties' dialog, enter the Oracle service name in the 'Data Source' field, and the user name and password as required.

Click on the OK button. The 'Project Transfer' dialog redisplays.

8

If required, select the 'Logfile' checkbox and type a path and filename for the data transfer log file.

9

Click on the Transfer button to begin the data transfer process.

10

When the process is complete, you have created a project on a Oracle database and can now connect to it and open it from Enterprise Architect.