import/export

[j33@1]

Running the 744 corporate build against oracle in hopes of trying to solve the model security problem.

Reason for export: cannot activate security in the model and have it stay activated or enforced for other clients.

Support says they cannot reproduce the problem so I thought I would export the model and import it into a fresh new schema made from the .sql files.

Test the export. All went fine. Went to import into a new local project to verify the import would work and all I get is dialog where I pick the file and a list box of models to import. I load the file and the listbox stays blank. You cannot import unless you can pick something from the listbox. Can we not export a model from an oracle backend and then import it into a local access model?

I really need some help with this product as I am getting very frustrated in its usability in a team/corporate setup.

TIA

[Bruno.Cossi]

What exactly do you mean by export? Did you export your model to an XMI file?
You may want to try the Data Transfer feature (menu Tools > Data Management > Data Transfer) that allows you to transfer your model between EAP files and DBMS repositories as you will.

Hope this helps!

Bruno

[j33@1]

To get this working:

create a new database schema in oracle,
export the broken model as xmi
load that into an EAP model
datatranser the EAP model to the new oracle model.

data transfer from the broken model in oracle to a new schema in oracle wouldn't work. I also got a few referential integrity errors trying to get the data into the new EAP from the xmi.

anyhow, working again in a team environment with security so the smiles are back.