Viewing data in file enabled h2 database

[veeseekay]

Hi chaps,

I have just started using h2 for my desktop application. Am using h2
as an embedded file based DB.

I need some basic info,

1)Can the data and the tables in the files be viewed using any sql
client(squirrel viewer) ?
2)Can I export the data in the file such that it can be imported into
another db?

Cheers!
TIA
~v

[veeseekay]

I just figured out that it is possible to connect to a file based DB
using DBVisualiser.
I guess my SQuirrel client is having some issues.

one question of mine is answered.

cheers!

[Dario Fassi]

Hi,
I use Squirrel with H2 on daily basis and work wonderful even with all plug-ins installed.
On Linux+JVM 64bits all works fine with any Squirrel version even the last 3.1.2
On W2K I need to use version 3.0 because some strange pauses with H2 and with other JDBC drivers too, but I don't try to find out why.

To export/import data to/from other dbms you can use CSV files or DBCopy among others.
Regards
Dario.

El 24/09/10 08:42, veeseekay escribió:

I just figured out that it is possible to connect to a file based DB
using DBVisualiser.
I guess my SQuirrel client is having some issues.

one question of mine is answered.

On Sep 24, 2:43 pm, veeseekay <veesee...@gmail.com> wrote:

Hi chaps,

I have just started using h2 for my desktop application. Am using h2
as an embedded file based DB.

I need some basic info,

1)Can the data and the tables in the files be viewed using any sql
client(squirrel viewer) ?
2)Can I export the data in the file such that it can be imported into
another db?

Cheers!
TIA
~v

-- 
Saludos,
Dario 

[Thomas Mueller]

Hi,

> 1)Can the data and the tables in the files be viewed using any sql
> client(squirrel viewer) ?

Yes, this should work.

> 2)Can I export the data in the file such that it can be imported into
> another db?

Yes and no. The SQL script generated using the SCRIPT command or
Script tool is 'lossless' meaning it contains all data that is
meaningful to H2. However, depending on the features you used, such
script will not always work on other databases. It's probably easier
to use a database copy tool such as the "SQuirreL DB Copy Plugin" at
http://dbcopyplugin.sf.net/ - see also the links at
http://h2database.com/html/links.html

Regards,
Thomas