This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Add a new tool to NetBeans that supports entity/relationship diagrams, including the ability to import schemas from existing databases and to generate the DDL from an E/R diagram to create tables that match the diagram.
As the visual query tool supports adding tables to a diagram and the keys & relationships are properly identified. A simple way to detach that from the "design a query" interface and save in some format which is exportable to an image or pdf file would be an excellent start to this. Followed by auto-layout, then DDL generation. This would make for a very useful tool. The MyEclipse database tool has a similar feature that I'm sorely missing after my switch to NetBeans.
FYI, an E/R module is being worked on by a volunteer team from the American University in Cairo. They have some working code, and are planning to make this available to the community within the next few months. Please vote for this if you think this is an important feature, as it will affect our prioritization as to when and if we will integrate their work into NetBeans proper.
Optionally it would make sense to add the capability to the UML diagramming code generation targets, as DDL. Same thing with the reverse engineering, reverse engineer to class diagram or some such.
Just want to let you all know we are very aware of the need for this feature. We are having to carefully prioritize features, and there are some other things we need to get to first (like basic improvements to our SQL Editor). It is encouraging that MySQL Workbench has solid E/R diagramming capabilities - have you looked at it? We are in the midst of discussions with the team that built this to figure out how to best integrate this functionality into NetBeans. Regarding using UML, yes, that has come up before and is another approach. We'll definitely keep that in mind, thanks for the tip.
We're working with a customer who is heavily invested in Oracle technology, and JDeveloper 10g handles this quite nicely. However, I was trying to converge upon a single IDE for our developers and NetBeans satisfies most of our Java EE development needs quite nicely. NetBeans has come a long way for Enterprise level devleopment, but not having good browsing and authoring support for something as fundamental as the ER diagram of a database is a big hole. It's actually discouraging that the feature was available as a pluging previously and has been lost in the shuffle. I suspect the low vote count is because people are looking to other tools, but please consider prioritizing this higher in the queue since it is a very highly requested feature for Enterprise Architects and Developers.
Thanks for this request. It has been on the middle tier of our priority list, based on the surveys and interview we have done it is not a top priority for most developers, and it is a very large feature. Each time someone takes the time to put a request in for this, it moves up in priority, so you are definitely heard. We are focusing currently on features that are even more of a priority for users, in particular a better SQL editor. But this is definitely on our radar.
We're using NetBeans since quite a long time and having this feature would definitely enrich it. I just stumbled upon this issue looking for info on how to create the er diagrams for a rather large db (ofbiz). Seems we'll still have to use eclipse for that in the meantime ...
Yes, there are a lot of votes for this issue. E/R diagram is not a small feature. I'd like comments from watchers of this issue: is a read-only diagram a good first step? Or is it not worth it unless it's read/write?
I would like to see read/write capability, so that I can integrate these with Data Management product suite (specifically ETL Editor), our MDM users are also very interested in this.
David, I would be satisfied with read-only diagram. I think we have enough feature in the IDE to modify schema and data, but only schema visualization is missing.
David, I concur with jhorvath that developing read-only capabilty would be a valued first step. Regards, Opher.
IMO a read-only diagram would be a good first step, having schema visualization integrated would sure be a worthy feature.
Read only diagram would be great to start.
This is a prior feature from my point of view. So, +10 for the support of ERD diagram with Netbeans 6+.
This would be a very important feature for me as well. Previously I've been using Azzurri Clay in Eclipse, which does most of what I need. I recently switched to NetBeans for a new work site, and am sorely missing this capability.
Many people (including myself) develop applications db driven; and so the very first tool they need is an ER designer. So this would be a great enhancement especially when you want people to migrate to netbeans.Thanks a lot!
*** Issue 34578 has been marked as a duplicate of this issue. ***
Like davidvc i use JDeveloper to build E/R-diagram. It will be nice have such tool in NetBeans. Thank you.
It would be a good thing to be able to reverse engineer a database and create an ERD for databases that we establish connections to, like MySQL, Oracle, and others. (especially MySQL).
I need supports entity/relationship diagrams! Thank you.
I'd like that Netbeans supports entity/relationship diagrams! Thank you.
Reassigned to new owner.
Just like to add a vote for this feature. It's been very useful in the past. Thank you. John Hogan
dalcais10, please don't change version when this issue was filed. Thanks
please don't change version when this issue was filed. Thanks
We need that tools to make a really "Le seul IDE dont vous aurez besoin", an Entity relationship plugin interfaceable by jdbc with any database, and supporting the Merise analyse methode and able to convert it to a UML ERD. Defenetly you'll become the number one in france with that kind of tools.
We always must be on top of Eclipse. If they have and very nice job that they did, than we must have
Netbeans should have this out of the box .
*** Bug 68349 has been marked as a duplicate of this bug. ***
It will be great feature of NB to support ERD designer with various RDMDS support! Best Regards, Alexey Makhov.
And... 7 years later... It's not like ER diagrams or databases are necessary to most of business infrastructure so I guess it is reasonable that Netbeans ignore this sort of trivial functionality request. But it's ok if you're one of the weird people designing databases. ERMaster is pretty damn great. You just have to put up with Eclipse for it. I love netbeans for its excellent polish and integration. But frankly the shiniest car in the world is useless without wheels and this is where Eclipse is absolutely killing netbeans.
Probably for a lot of developers this plugin can solve their need: http://plugins.netbeans.org/plugin/53057/jpa-modeler It can generated class diagrams from database and sql code from class diagrams among other important features.