Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: jimbo on January 18, 2013, 10:54:51 am

Title: What is the best database for the EA datastore?
Post by: jimbo on January 18, 2013, 10:54:51 am

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.

Title: Re: What is the best database for the EA datastore
Post by: Aaron B on January 18, 2013, 11:51:57 am

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

Title: Re: What is the best database for the EA datastore
Post by: Sunshine on January 18, 2013, 01:06:17 pm

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.

Title: Re: What is the best database for the EA datastore
Post by: Stoppy on January 18, 2013, 02:42:44 pm

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 :D

Title: Re: What is the best database for the EA datastore
Post by: jdoran-anglo on January 25, 2013, 02:52:36 pm

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.

Title: Re: What is the best database for the EA datastore
Post by: OpenIT Solutions on January 29, 2013, 04:48:10 am

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.

Title: Re: What is the best database for the EA datastore
Post by: qwerty on January 29, 2013, 05:06:40 am

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.

Title: Re: What is the best database for the EA datastore
Post by: Helmut Ortmann on January 29, 2013, 06:38:19 am

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