Best approach for copying multiple tables from one database to another? Follow
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.
Please sign in to leave a comment.
there is no easy way at the moment. Please follow and vote for this feature request.