Which DBs at EA 10.0 for fwd /rev engineering?

[dana n]

Which specific DB platforms and versions does EA 10.0 support for forward and reverse engineering? Most of the fact sheets and other available documentation seem to only reference EA v9.

Wondering specifically about support for SQL Server 2008 R2, SQL Server 2012, Oracle 12c, and the latest MySQL, DB2, and PostgreSQL versions.

[skiwi]

http://www.sparxsystems.com/enterprise_architect_user_guide/10/database_engineering/supported_databases.html

[dana n]

http://www.sparxsystems.com/enterprise_architect_user_guide/10/database_engineering/supported_databases.html

Thanks for that. Any idea which version(s) of DB2 are supported? The reference cited above just generically says "DB2".

Also wondering what version(s) of MySQL are supported--and if the non-commercial MySQL fork/branch named MariaDB is supported--and if so which version. Same for PostgreSQL--which version(s) of it is supported?

[qwerty]

There are a number of recent threads about the MySQL version. MariaDB is not officially supported, but as it is from the same developer as MySQL (actually the prefixes are the names of his daughters) you can try to replace MySQL with MariaDB. This is just a good guess, not based on any experience.

No idea about DB2 and PostgreSQL. I only know that people had good experiences with the latter according to their posts here. You could mail Sparx sales support for details.


q.

[dana n]

For a particular project, I'm not yet committed to either MySQL (and its forks) or PostgreSQL. How difficult would it be to develop a DB model in EA using one DB, then possibly migrating to another. Since EA doesn't seem to allow starting with a Conceptual DB Model--last time I used it, I believe I had to choose a specific DB type to start building a DB model.

One issue I'm facing--I know very little about MySQL other than that it's quite common for use on the web and very fast. But it seems not to be a full-fledged RDBMS, e.g. at some point--possibly even the present--it doesn't or didn't have FK constraints (that would be a show stopper for me because that sort of biz logic I prefer to have the RDBMS enforce).

Whereas PostgreSQL is a full-fledged RDBMS, evidently close in feature parity to SQL Server and Oracle. At least to the extent that, if you follow the GIS vendor Esri (of which EA supports developing ArcGIS geodatabases), PostgreSQL is one of the DB platforms Esri supports for Enterprise geodatabases--but not MySQL.

There are a number of recent threads about the MySQL version. MariaDB is not officially supported, but as it is from the same developer as MySQL (actually the prefixes are the names of his daughters) you can try to replace MySQL with MariaDB. This is just a good guess, not based on any experience.

No idea about DB2 and PostgreSQL. I only know that people had good experiences with the latter according to their posts here. You could mail Sparx sales support for details.


q.

[qwerty]

EA is not really a tool to design/deploy databases. Probably you should look at something like ERWIN (I guess that it's still in use).

However, you can start with a conceptual class model and then have EA transform that to either RDBMS which you then can refine. Have a look in the help for "transformation". It's not difficult to run the pre-defined transformation. If you're skilled enough you can even modify the transformation script to create specialized target systems.

q.

[dana n]

Thanks Qwerty. I know ERWIN and PowerDesigner would be superior tools. But this is for a personal project and I don't have USD 3K to 5K+ for a license.

Will look at the conceptual class model. Or suppose I could always just pick a DB platform--either MySQL or PostgreSQL. And if I didn't want to continue with it, I could forward engineer, then reverse engineer back into EA. Of course I'd probably lose lots of useful metadata. Will also have to look into the transformations you mentioned.

Possibly time to create a new thread to see if anyone's out there using EA specifically for DB design--and how they get around missing features compared with the much more expensive purpose-built DB modeling / design / deploy tools like ERWIN, ER/STUDIO, and PowerDesigner.

EA is not really a tool to design/deploy databases. Probably you should look at something like ERWIN (I guess that it's still in use).

However, you can start with a conceptual class model and then have EA transform that to either RDBMS which you then can refine. Have a look in the help for "transformation". It's not difficult to run the pre-defined transformation. If you're skilled enough you can even modify the transformation script to create specialized target systems.

q.

[qwerty]

Good luck then. I guess in your case EA is not the worst choice ;-)

There are quite a couple of guys here that posted things related to ERWIN. So you're encouraged to start a thread asking them directly.

q.