Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: bknoth2 on February 11, 2018, 09:49:44 am

Title: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: bknoth2 on February 11, 2018, 09:49:44 am
When I transfer a file through the menu system (Configure/Transfer/Project Transfer - DBMS to File) the resulting .EAP file is about 56MB. When I use the script below, the .EAP file is about 12 MB. Any idea what the difference is?

Thanks

(I left out the strings that define paths. Here's the critical part of the script):

     dim eapString
   eapString = "EAConnectString:BARDA EA DB --- DBType=4;Connect=Provider=MSDASQL.1;Persist Security Info=False;Data Source=EA DB"
   
   dim repository
   dim projectInterface
'   set repository = CreateObject("EA.Repository")
   set repository = GetObject(, "EA.App").Repository

   'get project interface
   set projectInterface = repository.GetProjectInterface()

   projectInterface.ProjectTransfer eapString, TargetFilePath, LogFilePath

end sub

main
Title: Re: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: qwerty on February 11, 2018, 11:13:37 am
Quite strange. Though I would not really care about the difference.

My 1st hard drive for my Atari ST had 32 MB. That time I would have cared. But now I have a little SSD with 256 GB (since more than 5 years and only 50% filled).

q.
Title: Re: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: Nizam on February 11, 2018, 09:31:37 pm
Thats a significant difference. Did you try running 'compact file' option in the transferred EAP.? what is the resulting size of the model?
Title: Re: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: bknoth2 on February 12, 2018, 09:24:47 am
Thats a significant difference. Did you try running 'compact file' option in the transferred EAP.? what is the resulting size of the model?
That was it! Compacting it reduced it to 10 MB and compacting the 12MB file also reduced it to 10MB.

Thanks, I didn't know about that feature.

- Bruce
Title: Re: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: bknoth2 on February 12, 2018, 09:26:52 am
Quite strange. Though I would not really care about the difference.

q.
I care because I thought valuable information might be missing. Nothing worse than a backup that isn't complete.

- Bruce
Title: Re: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: Nizam on February 12, 2018, 06:30:06 pm
That was it! Compacting it reduced it to 10 MB and compacting the 12MB file also reduced it to 10MB. - Bruce

Good to know there wasn't any data loss. I wasn't aware the two ways of doing PT will yield such different sizes..
Title: Re: ProjectTransfer from DBMS shrinks my output EAP file?
Post by: qwerty on February 12, 2018, 09:51:55 pm
Yes, loosing information is awful. But M$-Access is notorious for wasting space in all circumstances. You need to run a DB compact every now and then to get rid of waste.

Strange though that Menu and Automation result in different size. Well, it's probably just "normal" EA behavior.

q.