I'm very interesting in inexpensive (better free) SQL query tool for working with multiple databases.
Generally speaking it should works with all databases which Hibernate supports, but it must work with Mi开发者_开发技巧crosoft SQL Server (2000/2005/2008), Oracle (9i/10g/11g), Postgres 8.x, Sybase, Firebird, MySQL and HSQLDB.
Must have features:
- SQL code completion
- Syntax highlighting
Nice to have features:
- Hibernate integration
- Database specific options (like query execution plan)
Not sure if it worth to mentioned, but it will be used together with Eclipse (multiple workspaces).
My favorite is Squirrel SQL. Works well, simple to set up, nice GUI, works with all JDBC databases.
http://squirrel-sql.sourceforge.net/
I really liked SQUrrel until I discovered DBClient THere's also DbVisualizer but it's not free anymore
I'm really surprised nobody mentioned any Eclipse plugins which will fit neatly into your requirements. See my answer to this question. Also, MyEclipse recently released a cool visual query builder which you might want to check out.
i think everyone will give you same solution, squirrel sql ,we are all using same tool =)
精彩评论