Author Topic: EA 9: database format support (Read 5006 times)

skiwi · « **on:** February 17, 2011, 11:18:52 am »

With Access 2007 (and now 2010) file format well established, will EA 9 support the newer format, and also change the current default format to something better (ie more reliable, and better supported)?

Sunshine · « **Reply #1 on:** February 18, 2011, 10:55:46 am »

Good question I'd be interested in that answer too.
Although should we not be using a real database Skiwi?

skiwi · « **Reply #2 on:** February 18, 2011, 11:26:19 am »

Well its horses for courses sunshine.
We put our enterprise models in a server hosted relational database, these tend to be larger with an indefinite life span.
Solution and project work goes in files on the local file share (reducing bureaucratic and administrative cost).
Note that Sparx claim that they support "MS Access (all versions)", but when I made an attempt to use an accdb file I could not get it to work..

Paolo F Cantoni · « **Reply #3 on:** February 18, 2011, 11:31:35 am »

Quote

[size=18]...[/size]
Note that Sparx claim that they support "MS Access (all versions)", but when I made an attempt to use an accdb file I could not get it to work..

Did you connect to it as a Server? I think that's possible.

HTH,
Paolo

skiwi · « **Reply #4 on:** February 18, 2011, 12:00:18 pm »

I tried to follow the instructions,
but ran into problems and out of time,
... next christmas !

Paolo F Cantoni · « **Reply #5 on:** February 18, 2011, 12:11:34 pm »

Quote

I tried to follow the instructions,
but ran into problems and out of time,
... next christmas !

Maybe that was your problem...
Just tried my way:

Open .EAP file with Access 2007
Convert to .accdb
Open EA
Use Connect to Server (using the OLDB driver specified in the instructions)
EA opens repository.

2minute job!

Don't know why Sparx suggested transferrring the project. But I haven't done any extensive testing...

AND it would be MUCH better if EA supported .accdb as a native file system.

HTH,
Paolo

skiwi · « **Reply #6 on:** February 18, 2011, 12:20:28 pm »

Nice! [smiley=thumbsup.gif]

B546 · « **Reply #7 on:** February 19, 2011, 02:56:05 am »

Quote

With Access 2007 (and now 2010) file format well established, will EA 9 support the newer format, and also change the current default format to something better (ie more reliable, and better supported)?

I'd prefer SQLite.
http://www.sqlite.org/

It's rock solid, has great cross platform support, and has no trouble getting really large.

Sparx Systems Forum

News: