One Repository multiple project configuration

[xyrus]

We are using Oracle as the DB Repository. Created the schema and ran the sql. Lets say- I have two project (A and B) in EAP format. I can transfer project A to Oracle DB Repository using Project Transfer Option. However, when I transfer project B to Oracle DB Repository, it overrides the project A.
Somehow- I have "One Repository one Project " configuration. Could you please help me so that I can have multiple projects in a single Oracle DB Repository.

Thanks,
X

[smendonc]

The project transfer functionality will always completely overwrite the target with the source.  In your case this means the last EAP file transferred will overwrite the first one in the Oracle repository.

To achieve what you want, you can use project transfer to transfer the first EAP file to the repository.  For each succeeding EAP file you can export to XMI and then import the XMI into the repository.  The imported XMI will come in as a new Project.

Stan.

[xyrus]

Thanks Stan for your reply.

Is this limitation of "one project one repository" in database .. anyway related to Oracle ? I mean, i can switch my Database if that helps in anyway.

Also - The link http://www.sparxsystems.com/downloads/whitepapers/EA_Deployment.pdf

discusses about "One Repository – Multiple Projects" on page 6. So, I was thinking .. that its feasible. I might be wrong.

[Aaron B]

The method described by Stan is the correct way to host multiple projects within a single repository.  The data transfer should only be used to upload the first project.  Any additional projects must be imported using XMI.