Hi,
You could create an in-memory database (locally on your machine) using the
database URL jdbc:h2:mem:test, and then create a linked table ("create
linked table...") to your target database (where you need the data). Then
import to this linked table using "insert into linked_table select * from
csvread". This is quite a bit slower than local import, but possibly it is
easier than to move the data to the target machine first.
Have I got to FTP the data there first or can it be done through H2?
People usually transfer the data using the operating system (it doesn't have
to be FTP). But I understand this is a bit complicated if you have a
client-server application.
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.
