Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

JMyETL CUBRID Tutorial


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:

main.class=com.sql9.jmetl.MainFrame
classpath.1=*.jar;.
splash.image=SplashScreen.bmp
vm.location=c:\Program Files (x86)\Java\jdk1.7.0_07\jre\bin\server\jvm.dll
vmarg.1=-Xms64M
vmarg.2=-Xmx512M

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

vmarg.1=-Xms64M
vmarg.2=-Xmx512M

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

jmyetl_window.png

Choose SourceDB and Targetdb from the dropdown list.

jmyetl_select_sourcedb.png

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.

jmyetl_table_list.png

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
Page info
viewed 2006 times
translations en
Author
posted 2 years ago by
CUBRID
Contributors
updated 2 years ago by
View revisions
tagged
Share this article