ProjectTransfer from DBMS shrinks my output EAP file?

[bknoth2]

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

[qwerty]

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.

[Nizam]

Thats a significant difference. Did you try running 'compact file' option in the transferred EAP.? what is the resulting size of the model?

[bknoth2]

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

[bknoth2]

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

[Nizam]

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..

[qwerty]

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.