Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - kodo65

Pages: 1 [2]
Hmmm, up 'til yesterday I'd used the beta v9 of EA and have experienced problems while trying to generate "proper" SQLite-DDL. Today I decided to give the production release of v9 a try and, voilá, the generated DDL checked out 100% = me VERY happy. It looks like I'm, from now on, able to model my SQLite databases in EA and then execute the DDL-script in, say, the SQLite Manager FF plugin:-)


Any comments on this?


Hi Aaron!

I was not referring to how to establish the foreign key association. I'm referring to how EA generates the resulting SQL DDL for each engine supported (Oracle, SQLServer2005/2008, Informix...). Unfortunately they all have their idiosyncrasis and SQLite is no exception to this fact.

The mere possibility to just establish foregin key relations between table stereotypes is very limited, unless the tool is aware of the differences between the physical implementation of them. Again, I prefer to have a pragmatic approach to this as it might be that I don't know of any esoteric setting in EA which will make it aware of these differences, but I'd thought it would definitely be "on" by default, but then again, I could be wrong...



Great news - thank you! I still have one more question though regarding referential integrity. In order to have EA generate valid foreign key constraints which will enable referential integrity in the physical database, it needs to know HOW to provide the correct syntax for SQLite. Again I might be "out in deep water here" but I think I'm correct when I say that EA needs to be tweaked somewhat more to fully accomodate SQLite or...? I know that alot of people think that SQLite is not "a proper db-engine" (I've definitely been one of them) but there are situations where it really shines! Please, Sparx, "spark up" the SQLite support just a little bit more:-)

Again - thanks for a great product, I hope I don't sound too fastidious:-)

Hi again!

Hmm, seriously! It's great that EA supports reverse engineering of SQLite-databases but generating DDL for that target is a chore currently! It can well be that I don't have a 100% grasp of *how* to do this in v9 of EA but all referential integrity stuff coupled with the primary key declarations MUST simply be known to the tool, otherwise there will be a huge need for manual tweaking of the resulting DDL-script. This is B.A.D.

Pity - I really like EA!


Hmmmm, I just upgraded to v9.0.904 (Build: 904) and went into one of my physical db diagrams, double-clicked a table and...??? I couldn't find SQLite as a database type in the "General" setting.

Has this been postponed or...?


From the release notes of the EA 9 beta:

SQLite added as a supported database for both ODBC import and DDL generation

Great news! Thanks!


I wonder if there is, or will be, support for database modelling towards SQLite-based physical databases?

Kind regards

Hi Simon!

Well, that's exactly what I was looking for... the file that is. So far I haven't been able to find any file though. The material is unclassified/releasable so there's no confidentiality/classification involved which makes me a little puzzled why it's not available. I mean there are a huge number of parties who use it... I sure somebody on this forum could point me in the right direction.



Is there anybody out there who have an NTL-file which is possible to import into EA? I have a PDF-document which contains all of the Nato Task definitions and like to have them imported into EA instead of having to manually add them to my EA-model. A DAUNTING task to say the least...

Many, many thanks in advance!

Pages: 1 [2]