Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


The installation of JMyETL is fairly easy. You just need to follow a few simple steps.

First, download JMyETL and extract it. In the extracted folder, find jmyetl.ini configuration file and edit it to adjust the value of vm.location to your {JAVA_HOME}\jre\bin\server\jvm.dll.

Make sure that the path correctly points to a jvm.dll file from a Java 32 bit version otherwise you will keep getting a "Error starting Java VM." error. Usually the 32 bit version is located in C:\Program Files (x86)\ directory. If you already have a 64 bit version of JDK, you will also need to download the 32 bit version. The recommended JDK version is 1.6 or above.

The final confirmation file will look something like:

vm.location=c:\Program Files (x86)\Java\jdk1.7.0_07\jre\bin\server\jvm.dll

Optionally, in jmyetl.ini configuration file you can also set the memory limitation for Java Virtual Machine (JVM). The default values are:


Now open JmyETL.exe program. The following window will show up.


Choose SourceDB and Targetdb from the dropdown list.


For both fill out the {host}, {database}, {port} values and enter user and password information in the next two text fields. For example, CUBRID database connection URL should look like jdbc:cubrid:localhost:33000:demodb::: and user is dba with an empty password. MySQL connection URL should look like jdbc:mysql://localhost:3306/hibernate.

When connecting to a CUBRID database, make sure it has been started. For Access Database, you don't need to create the mdb file in advance. If it doesn't exist, JMyETL will create it for you.

Then click the Test Connect buttons to ensure both connection URLs are correct. If the connection has been successfully established, first, you will notice that Test Connect button becomes green. Second, on the left panel you will see a list of tables from the source database.


Now select all or some of tables which you would like to export from SourceDB to TargetDB. Once ready, click the Start Import button. Done! This will automatically create corresponding tables in the TargetDB and import all records from SourceDB.

comments powered by Disqus
문서 정보
viewed 1758 times
번역 en
posted 2년 전
마지막 수정시간 2년 전
변경 내역 보기
Share this article