Can't export DBMS->EAP?

[Wowbagger]

I have a model stored in a DBMS (MySQL), and I'd like to export it to an EAP so that I can allow somebody who does not have access to the database the ability to see the model.

So, I do a Tools->Data Management->Project transfer->DBMS to EAP, and I run into the following problems:

1) I cannot specify a "new" EAP file - it must exist already. If I try to give a file name for a file that does not exist already, I get an error "An Error has Occurred: Couldn't find file foo.cp".

2) So, I create a new project in an EAP file, and then do the operation. I get the warning that I will overwrite everything in the target, I click OK, and .... Nothing. No progress bar, an empty xfer.log file is created, and the EAP isn't changed.

I am an admin on the project, so I know I have the privs to do the operation. What gives?

All I want to do is punch the project out as an EAP file - why is that so hard?

[Paolo F Cantoni]

I found similar problems using MS SQL Server.  Turns out EA (project transfer) is very susceptible to problems in OLEDB implementation.  Transfer to DB only works with a very limited subset of the available MS SQL Server OLEDB drivers.  So my guess (since I don't use MySQL) is an OLEDB driver issue.

If someone is able to do the project transfer using MySQL perhaps they can post versioning details of the OLEDB provider they are using - it will help others.

HTH,
Paolo

[Geert Bellekens]

If you really need it fast and you don't find a solution for the project transfer you could try to export the project to xmi.
If it is a large model then you better create multiple xmi files.
You can then import the xmi's into another model. (without loosing everything).
It's not exactly the same as the project transfer (xmi export will not export things like resources, settings, users etc...) but at least it'll get you going.

Geert