Hi,

> I want to create this predefined schema and data
> using some visual tool

H2 doesn't come with such a tool, but there are many tools available,
for example DbVisualizer: http://www.dbvis.com/ - for other tools see
http://h2database.com/html/links.html "Database Frontends / Tools".
Missing on that page is OpenOffice Base (I will add it) but I don't
remember if it allows to create tables using a visual tool.

> What is the best way to do this?

I usually "design" table definitions in text form (same as with
regular source code). In my view graphical tools are overrated :-) but
I admit I used UML tools (for software) and Microsoft Access (to
visualize table relationships).

> I can't imagine people going around exporting and importing their .sql
> files in order to manipulate it's schema or data?

I do :-)

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to