What is the best database for the EA datastore?

[jimbo]

We are about to setup EA. What are the pros and cons of different databases for EA? We have a user base of 5 users. Some users will connect over WAN connection. We were thinking PostgreSQL might be a good choose.

[Aaron B]

Personally, I'd recommend MySQL.  It's always been the better performer from what I've seen.

[Sunshine]

I've used MS SQL with no issues. Had issues with Oracle but think thats been down to the DB Administer so suggest taking into account skills of your DB administrator as well.

[Stoppy]

I've used SQL in the last two organisations I have been in with no performance issues.

Have also used the instances over VPN with delay's but that's cause ADSL Connection.

Agree with Sunshine, we had a good DBA at my last organisation keeping things up to date and optimized.

Stoppy

[jdoran-anglo]

MS SQL has worked well here too.

Have recently been investigating MS SQL (Azure) for smaller projects, and it seems to work well too. Just need to be aware that you need a different SQL setup script for Azure.

[OpenIT Solutions]

The issue with Sparx over WAN is not the db but the network bandwidth. The WAN Optimizer will help a little. But i'm leaning towards a pure version control option for my organisation as we have a global user base and some users are having to wait up to 30 seconds when placing an element on a diagram. The server is based in London, these users are based in Singapore.

Regards,

Jon.

[qwerty]

The problem moves then to the VC where from you get the XML data in order to synch your models. I doubt that this will improve performance. Trial and error, I guess. The best of course is a fat, fat wire between the single sites.

q.

[Helmut Ortmann]

Hi,

we have a

• Central DBMS (SQL Server, that's not so important)
• Version Control (MKS, SVN or other would also do)
• Supplier connected via VPN

That's of course boring (small wire and VPN isn't the hit).

Now: Everyone remote has a private *.eap file.

With:

• Version Control (Check out\Check in)
• Once a week update of the central stored *.eap file

we are able to work.

Usually everybody works on a limited amount of VC objects. That means:
- Checkout via wire
- working local on *.eap file
- Checkin via wire
- Sometimes (weekly or so) update of the local *.eap file

If you are interested in details contact me per E-Mail.

Kind regards,

Helmut