Book a Demo

Author Topic: Transfer a single rootNode from DBMS to .EAP file?  (Read 4265 times)

Mesple

  • EA User
  • **
  • Posts: 30
  • Karma: +0/-0
    • View Profile
Transfer a single rootNode from DBMS to .EAP file?
« on: November 20, 2019, 08:25:11 pm »
Hi all,
I'd like to transfer only one rootNode of my model hosted on a SQLServer into a new .eap file.
Is-it possible?
I tried to do that by using the export/import .xmi function but it doesn't work (Memory fail during import)  :-[
Thanks for your response.

Olivier

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #1 on: November 20, 2019, 08:35:14 pm »
It might be faster to do a model transfer and then delete all the other rootnodes.
If it's a lot you might want to start deleting a bit lower in the tree to keep the units to delete a bit smaller

I once wrote a script that did a bottom up delete, but even that sometimes failed.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #2 on: November 20, 2019, 08:35:52 pm »
Either the XMI way (which does not include resources like images etc.) or simply transfer (Configure/Transfer/Model) the whole model and delete the unneeded roots afterwards (plus compress .eap).

q.

Mesple

  • EA User
  • **
  • Posts: 30
  • Karma: +0/-0
    • View Profile
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #3 on: November 20, 2019, 08:44:14 pm »
Thanks for your advices. I tried to do the transfer of all the roodNodes of my model from DBMS to .EAP, but the file created is to too big for Access  :-\.
Any idea?
Olivier


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #4 on: November 20, 2019, 09:11:04 pm »
Transfer on the SQL Server to a new one. Remove the roots. Transfer the rest-model.

q.

Mesple

  • EA User
  • **
  • Posts: 30
  • Karma: +0/-0
    • View Profile
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #5 on: November 20, 2019, 10:32:03 pm »
Ok, thanks
Olivier

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #6 on: November 20, 2019, 10:59:39 pm »
Thanks for your advices. I tried to do the transfer of all the roodNodes of my model from DBMS to .EAP, but the file created is to too big for Access  :-\.
Any idea?
Olivier
How big is too big?
Are you sure your database isn't carrying around way too much data (such as auditing)

Geert

Colin Coates

  • EA User
  • **
  • Posts: 46
  • Karma: +0/-0
    • View Profile
Re: Transfer a single rootNode from DBMS to .EAP file?
« Reply #7 on: November 21, 2019, 12:04:39 am »
If the repository contains a lot of stuff, I suggest transferring it into a FEAP (FirebirdSQL) is probably better than an EAP.

FEAPs also support longer character fields than EAPs too...