Copying a database JPA

Question

I have a working code that basically copies records from one database to another one using JPA. It works fine but it takes a while, so I wonder if there's any faster way to do this.

I thought Threads, but I get into race conditions and synchronizing those pieces of the code end up being as long as the one by one process.

Any ideas?

Update

Here's the scenario:

• Application (Core) has a database.
• Plugins have default data (same structure as Core, but with different data)
• When the plugin is enabled it checks in the Core database and if not found it copies from it's default data into the core database.

Answer 1

Most databases provide native tools to support this. Unless you need to write additional custom logic to transform the data in some way, I would recommend looking at the export/import tools provided by your database vendor.