GUI DDL Tool for H2
Bubbles
Is there any tool to graphicaly design tables? It doesn't need to have
fancy data modeling functionalities (like visualizing tables and
foreign keys), though they would be nice.
The main problem is that it's quite painful to write all that DDL
stuff yourself, so it would really help to have a tool where you can
just check some boxes, rather than type constraint conditions by
hand...
Thanks!
tsukasa
surely worth its price. You can try it for free and see.
If you have some time to play, you can try too my toy gui, at
http://www.pincha.cl/tsuky , but it is in spanish and has very severe
limitations (things I don't use aren't implemented there, so for other
people is only a toy..).
tpoindex
On May 30, 1:44 am, Bubbles <montgome...@gmail.com> wrote:
> Hi!
>
> Is there any tool to graphicaly design tables? It doesn't need to have
> fancy data modeling functionalities (like visualizing tables and
> foreign keys), though they would be nice.
licensed.
http://www.sqlpower.ca/page/architect
Back in the 90's, I used this tool, which is now free (Windows only)
http://www.microsoft.com/downloads/details.aspx?FamilyID=27fe6786-a439-4286-b8b6-7a9b84cfa709&DisplayLang=en
I used it with ODBC drivers to a PostgreSQL database, so it in theory
could
work with H2. VisioModeler works both in entity-relationship and
object-role-model modes.
There is a tutorial for VisioModeler here: http://www.orm.net/pdf/VMuse.doc
and web site devoted to ORM: http://www.objectrolemodeling.com/
Thomas Mueller
H2 doesn't have his own tool yet (the plan is to extend the H2 Console
by re-using the 'table data editor' so that you can also edit table
definition; but that is not high priority so far). There are some
other third party tools such as OpenOffice, or:
http://www.dbsolo.com/
http://www.minq.se/products/dbvis/
http://executequery.org/index.jsp
http://sqldeveloper.solyp.com/index.html
http://sql-workbench.net/index.html
http://www.squirrelsql.org/
See also the 'links' section of H2.
Regards,
Thomas
Thomas Kellerer
> H2 doesn't have his own tool yet (the plan is to extend the H2 Console
> by re-using the 'table data editor' so that you can also edit table
> definition; but that is not high priority so far). There are some
> http://sql-workbench.net/index.html
My application does not support "editing" the structure of a table, so
it's not really applicable here.
And I will most probably not support it as well in the future.
I strongly believe, changes to a database model should be done by
maintaining a set of SQL scripts that can be put under version
control. Any other way of maintaining a non-trivial data model is
bound to give problems at some point in time, e.g. when moving from
test to production or something similar.
Thomas
Thotheolh
suggested and one software, Execute Query (http://executequery.org/
index.jsp) is rather simple to use catering to both JDBC and ODBC and
it's made using Java and Swing ... so more tools for Javaland to use
Java to handle databases. I think execute Query would be rather
recommended in my view.
Thomas Mueller
>> http://sql-workbench.net/index.html
> My application does not support "editing" the structure of a table
I'm sorry, I didn't know that.
> And I will most probably not support it as well in the future.
That unfortunate. If I was you, I would consider supporting it at some
point in the future.
> I strongly believe, changes to a database model should be done by
> maintaining a set of SQL scripts that can be put under version
> control.
I agree. The question is: how to create those scripts. If the scripts
can be created as a side effect of editing the meta data, you get the
script without having to type it manually (and without having to look
up the syntax). This is the way the Oracle tools work (last time I
checked): the tools display the SQL statements that would be executed.
That allows you to copy the statements, and at the same time you learn
the SQL statements.
Regards,
Thomas