On 2015-04-01 05:09 PM, Stephen Cprek wrote:
I'm working on migrating a populated gerrit H2 database to mariadb and although
I got this to work originally by using
the H2 SCRIPT command and a script to modify the file to fit mysql syntax it's
sloppy.
A better solution I feel is to do a CSVWRITE on each table and import that
directly into my new db. Every table works
perfectly except one, PATCH_COMMENTS, which has a column MESSAGE with user
entered data.
CSVWRITE is never going to be able to cater for everybody's use-case - the general answer is - just write some custom
JDBC code to export it :-)
Sorry.
Although now that I think about it, does mariadb support importing JSON?
Because it might make more sense to create JSONWRITE and JSONREAD functions, since JSON is much better at things like
escaping.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
