Best approach for copying multiple tables from one database to another?


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.

Yuriy Vinogradov
Comment actions Permalink

there is no easy way at the moment. Please follow and vote for this feature request.


Please sign in to leave a comment.