I have two databases with identical structure, one in MySQL and the other is HyperSQL. I can easily transfer a table or two in the DataGrip IDE (Copy to Database...), but to transfer the complete database is exhausting. There are 127 tables, and they need to be copied – or exported and then imported – in a specific order due to foreign key constraints.
I tried IDE-Macros (doesn't work). Exporting into a file, but the order of the tables is random. What is the best approach? Before I start developing a small solution in Java, I wanted to learn if there is an easier solution.