I"m looking at putting together a new system, and was wondering if there's an Eclipse tool that'll allow me to design the schema, generate a .df and then apply it to a db?
I"m looking at putting together a new system, and was wondering if there's an Eclipse tool that'll allow me to design the schema, generate a .df and then apply it to a db?
Not 100% an Eclipse plugin, but executed inside OpenEdge Architect is PCase from IAP:
http://www.tools4progress.com/pcase.html
It looks nice, and for $2.9 USD it better be!
Unfortunately that's a bit out of my price range right now....
Has anyone tried this?
http://marketplace.eclipse.org/content/mogwai-erdesignerng#reviews
That's not going to help much in generating a .df.
Have you consider using Enterprise Architect? Of course, I does a whale of a lot more than just ERD, but with Phil's plugin it will both read and write .df files.
And, who knows, you might find it useful for other things as well, including use cases, requirements, and activity diagrams for documenting the specs of new system to be built.
Have you consider using Enterprise Architect? Of course, I does a whale of a lot more than just ERD, but with Phil's plugin it will both read and write .df files.
As long as Phil hasn't updated his DF import, the big limitation of it is that it's not able to apply an modified DF file to an existing model. In that case it creates duplicate tables with is really painfull.
Yet another reason for PSC to release the source.
I would think, though, that if one had a version 1 DB and then modified the model to create version 2 schema, that one could output the full df into a new DB and then use the incremental df tool to produce the needed .df.
Yet another reason for PSC to release the source.
Yepp.
I would think, though, that if one had a version 1 DB and then modified the model to create version 2 schema, that one could output the full df into a new DB and then use the incremental df tool to produce the needed .df.
IMHO one time import is not enough. A (ER) modeling tool should be capable of importing external modifications of the model's source. Think of a schema from a third party application database where you have to apply schema changes to your model. So I'm not talking about updating the DB (delta.df), I'm talking about reflecting external changes in the model.
tamhas wrote:
That's not going to help much in generating a .df.
Have you consider using Enterprise Architect? Of course, I does a whale of a lot more than just ERD, but with Phil's plugin it will both read and write .df files.
And, who knows, you might find it useful for other things as well, including use cases, requirements, and activity diagrams for documenting the specs of new system to be built.
I have EA, I was hoping to find something that would work in an OEA environment.
My understanding was that Phil's tool *will* read incremental .df files, just not produce them.
I was just at an Ontario PUG meeting where one of the members took an existing open-source Eclipse plugin which could be used for designing non-PSC db's has been made into something that'll work with PSC db structures.
It looks to be exactly what I'm looking for, and extensible too!
I was just at an Ontario PUG meeting
Surprise
an existing open-source Eclipse plugin which could be used for designing non-PSC db's has been made into something that'll work with PSC db structures.
>
It looks to be exactly what I'm looking for, and extensible too!
Can you share some deails with us? Is that available as a customized plugin somewhere? What's the original plugins name and download/documentation site?
mikefe wrote:
I was just at an Ontario PUG meeting
Surprise
an existing open-source Eclipse plugin which could be used for designing non-PSC db's has been made into something that'll work with PSC db structures.
>
It looks to be exactly what I'm looking for, and extensible too!
Can you share some deails with us? Is that available as a customized plugin somewhere? What's the original plugins name and download/documentation site?
It was a great meeting.
The member has to do some stuff to it, and it'll be posted to OEHive.org when they're ready.