To get the table metadata, TransferDB queries the whole table . For large tables this was unusably slow.
My fix was to add a where clause that causes the metadata to return but no data gets found.
--- workspace/hsqldb/hsqldb/src/org/hsqldb/util/TransferDb.java 2011-08-17 10:58:37.537891854 -0500
+++ Downloads/hsqldb-2.2.6/hsqldb/src/org/hsqldb/util/TransferDb.java 2011-06-05...
2011-12-20 07:08:49 PST in HyperSQL Database...
