Author Topic: EAP-to-DBMS model transfer  (Read 583 times)

crequena

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
EAP-to-DBMS model transfer
« on: May 31, 2018, 08:32:26 pm »
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

  • EA Guru
  • *****
  • Posts: 9665
  • Karma: +176/-150
  • I'm no guru at all
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #1 on: May 31, 2018, 09:20:18 pm »
For what purpose do you want to automate that? And between which RDBMS?

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 8467
  • Karma: +207/-26
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EAP-to-DBMS model transfer
« Reply #2 on: May 31, 2018, 11:05:48 pm »
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

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #3 on: June 01, 2018, 12:36:03 am »
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

  • EA Guru
  • *****
  • Posts: 8467
  • Karma: +207/-26
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EAP-to-DBMS model transfer
« Reply #4 on: June 01, 2018, 01:43:47 am »
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

  • EA Guru
  • *****
  • Posts: 9665
  • Karma: +176/-150
  • I'm no guru at all
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #5 on: June 01, 2018, 05:56:59 am »
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

  • EA User
  • **
  • Posts: 678
  • Karma: +46/-3
  • Emoji's make you look younger
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #6 on: June 01, 2018, 08:56:09 am »
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

  • EA Guru
  • *****
  • Posts: 8467
  • Karma: +207/-26
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EAP-to-DBMS model transfer
« Reply #7 on: June 01, 2018, 03:05:05 pm »
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

  • EA User
  • **
  • Posts: 301
  • Karma: +9/-2
  • Model Sharing - Simplified
    • View Profile
    • Professional Model Collaboration
Re: EAP-to-DBMS model transfer
« Reply #8 on: June 02, 2018, 12:15:18 am »
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

  • EA User
  • **
  • Posts: 678
  • Karma: +46/-3
  • Emoji's make you look younger
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #9 on: June 02, 2018, 11:06:55 am »
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

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 6445
  • Karma: +55/-6
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #10 on: June 04, 2018, 09:17:42 am »
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.
Simon

support@sparxsystems.com

crequena

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: EAP-to-DBMS model transfer
« Reply #11 on: June 14, 2018, 11:56:17 pm »
Thank all for your replies.