I need to get a batch of data from a PostgreSQL db and import this into
HSQLDB. I think what I need to do is create a script file that I can
import with org.hsqldb.util.ScriptTool or via the Script command in the
Database Manager.
I already have a utility that will initialise the tables in HSQLDB, so
what I think I need is simply the INSERT statements to get the data
that was in PG into HSQLDB.
I don't have access to the PG db, so I tried an export of a current db
in HSQLDB using the Script command in DatabaseManager. This seems to
generate the appropriate file. When I tried to use ScriptTool to
import, with -script option referring to file, it seemed to process the
entire file, but when I look at the end script, it has ignored all of
the inserts and simply created the tables.
I am using 1.7.1 on Windows 2000.
Can anyone suggest what I am doing wrong, or if I should try this a
different way?
Thanks,
Neil
-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn
|
| 
