Hi, H2 supports the standard CSV format as documented in Wikipedia, including RFC 4180, and much more. If MariaDB doesn't support that (are you sure it doesn't?), then I suggest to ask _them_ why they are not compliant. You should probably ask at StackOverflow.com.
But yes, JSON export and import would be very nice for H2! Regards, Thomas On Thu, Apr 2, 2015 at 10:51 AM, Noel Grandin <noelgran...@gmail.com> wrote: > > > 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 h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
