Please note, new blog at http://www.acheron.org/darryl/

Wednesday, May 18, 2005DBedit plugin for Eclipse

A few people were talking about database plugins for Eclipse today, and DBEdit was mentioned. I can't believe I haven't found this plugin before -- it's really awesome.
DbEdit is a set of plugins for the Eclipse Platform that provide viewing, editing and designing capabilities using the JDBCTM API. It is not intended to replace any proprietary database management tool because it surely cannot beat them because the JDBCTM API has several limitations. Currently there are the following functionalities:
  • direct table data manipulation using the Table Editor
  • editing and executing of SQl statements using the SQL Editor
  • exploring database structure using the Tables View
  • scanning tables for search patterns with Eclipse integrated database Search Support
  • exporting and importing table DDL and content using Eclipse integrated Export/Import feature
  • compare tables using the table comparison
  • explore a schema's referential structure using the Visual Editor
http://eclipse-plugins.2y.net/eclipse/plugin_details.jsp?id=458
I got it up and running very quickly. I ended up downloading the Microsoft JDBC drivers for SQL Server. Now I don't have to have an instance of Query Analyzer or Enterprise Manager open just to do quick lookups. The decreased memory usage of not doing so also helps!

By Anonymous Anonymous, at 5/19/2005 12:35:00 am  

Thanks for the info. You spurred me to finally try and get dbedit working and I had moderate success (posted about it here). Any assistance you can offer with regards to getting the SQL driver working?



By Blogger Darryl Lyons, at 5/19/2005 06:21:00 pm  

You can try this post about getting the Microsoft JDBC drivers working (most of it applies to DBEdit).



By Anonymous Anonymous, at 6/01/2005 11:30:00 am  

Yeah, I use DBEdit for all of my DB work now... with Oracle and MySQL... very sweet!

- Sean Corfield



» Post a Comment