EAP-to-DBMS model transfer

[crequena]

Hi,

I see there is no automation to perform an EAP-to-DBMS operation.
http://www.sparxsystems.com/enterprise_architect_user_guide/14.0/automation/project_2.html

Does anyone know any alternative to do this without using EA's GUI?

Thanks.

[qwerty]

For what purpose do you want to automate that? And between which RDBMS?

q.

[Geert Bellekens]

Have you tried it?

I could image that it could work if you simply entered the .eap file as source, and the DB connectionstring as target.

Geert

[crequena]

Hi,

It's a SQLServer db.

Invoking the ProjectTransfer method from eap to dbms file just returns "false" and does nothing with the database.
Also, nothing gets logged.

It's not working neither from Java nor PowerShell:

$ea = New-Object -ComObject "EA.Repository" -Strict
$project = $ea.GetProjectInterface()
$project.ProjectTransfer("....eap", "DBType=1;Connect=Provider=SQLOLEDB.1;Persist Security Info=True;User ID=...;Password=...;Initial Catalog=...;Data Source=...", "D:\....DBMS.log")
$ea.Exit()

[Geert Bellekens]

Too bad, it was worth a shot.

Apart from copying the data table by table yourself, I don't really see a solution.

Geert

[qwerty]

It's not working neither from Java nor PowerShell:

I never tried that. The documentation seems to read as "works for EAP to EAP only" since they talk of file paths. Hmm. You should probably contact Sparx support. Likely they will respond "this is intentional" rather than "other DBs are missing and we'll fix that". But you never know.

q.

[Sunshine]

As eap files are MS Access you could have a look to see if MS Access has anything built in to do the transfer and see if you could automate it.
Alternatively if you have some coin you could use an ETL tool like informatica or similar to do the transfer.

[Geert Bellekens]

It's not working neither from Java nor PowerShell:

I never tried that. The documentation seems to read as "works for EAP to EAP only" since they talk of file paths. Hmm. You should probably contact Sparx support. Likely they will respond "this is intentional" rather than "other DBs are missing and we'll fix that". But you never know.

q.

It works fine from DBMS to .eap, which is probably its main use: create a usable backup file of your DBMS model.

Geert

[Nizam]

True, but it will be really good to have DBMS to DBMS, we are doing a number of workarounds for backing up large models (as migrating to EAP files mostly fails)

[Sunshine]

True, but it will be really good to have DBMS to DBMS, we are doing a number of workarounds for backing up large models (as migrating to EAP files mostly fails)

Yeah I do that too backing up a SQL repository to eapx file. We have SQL database back up daily too but don't have confidence in our support vendor so the eapx files are a insurance policy. Upto around a 1GB now.

[Simon M]

The API call for ProjectTransfer intentionally only targets eap files. It's their as a backup mechanism, and we don't want it to be possible to destroy a model using it.

[crequena]

Thank all for your replies.