When i try to migrate a large table from mysql (data only) using the online migration tool in the EnterpriseDB Migration Studio 8.3 i get the following error:
Exception in thread "Thread-22" java.lang.OutOfMemoryError: java heap space.
I have added the following to migrationstudio/runMigrationStudio.sh
The OutOfMemoryError always occurs when the JVM doesn't allocate sufficient space during the object creation.
Mainly, the migration will have many objects and classes. The heap size can be mentioned like -Xmx1024M -Xms1024m
The no. should be the 1/2 of the RAM in the system.
For example, if the machine has 4 MB RAM, -Xmx2048M -Xms2048m should be set.