Hi Noel in MySQL itself, it is possible to skip constraint checks on create tables (apparently) via SET FOREIGN_KEY_CHECKS = 0;
(http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_foreign_key_checks, "Disabling foreign key checking can be useful for reloading InnoDB tables in an order different from that required by their parent/child relationships.") How that is actually implemented in the MySQL server, and whether that's at all possible in H2, is another question. In practical terms, my problem is that I am not the owner of this schema, so if I create a cleaned-up version of the database dump, with tables in dependency order, then I have to maintain that across changes to the original schema. I'm already doing some simple pre-processing to remove MySQL syntax that H2 appears to not accept (things like the ENGINE=). But with tables that's a more time-consuming problem to solve as it involves re-ordering chunks of the script. If this behavior is not supported in H2, I'll see if I can get separate dumps for tables without constraints, and for the constraints alone. Thanks again for the clarification. Patrick On Tuesday, July 16, 2013 6:15:49 PM UTC+2, Noel Grandin wrote: > > Sorry, there isn't much we can do about that. > >> >> >> -- 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/groups/opt_out.
