CUBRID Migration Toolkit Process

Comparison of migration methods

The four of migration methods, the method#1 is very fast and the method#6 is very slow. But, it has no best way to migration because it is impossible to use on particular operating environment.

Sorts of the source, the destination data source type

• Source data : JDBC, XML (mysqldump, using xml export option)
• Destination data : JDBC, Offline LoadDB, Export LoadDB file

Method#1: XML - Export LoadDB

• Features
• It is suitable for a XML file about 10~20G bytes, because of analysys problem.
• Fastest. But, it is inconvenient way. Because, users have to use loaddb utility after exported,

• Begining the migration wizard
• Step 1: Select data source - select the MySQL XML dump file
• Step 2: Select target database - select the Database Unload
  
• The following step is same as a default process

Method#2: XML - Offline LoadDB (running on CUBRID above 2008 R 4.1 patch 2 version)

• Features
• Similar to method#1, but it is upload exported file automatically.
• It should be supported a remote loaddb function on CUBRID server.
• If you want to know the remove loaddb function, please check Expand to the remote loaddb function on CUBRID Manager Server page.
  

• Begining the migration wizard
• Step 1: Select data source - select the MySQL XML dump file
• Step 2: Select target database - select a Offline Migration
• The following step is same as a default process

Method#3: XML - JDBC

• Begining the migration wizard
• Step 1: Select data source - select a MySQL XML dump file
• Step 2: Select target database - select the Online
  
• The following step is same as a default process

Method#4: JDBC - Export LoadDB

• Begining the migration wizard
• Step 1: Select data source - select a MySQL XML dump file
• Step 2: Select target database - select the Database Unload
  
• The following step is same as a default process

Method#5: JDBC - Offline LoadDB

• Begining the migration wizard
• Step 1: Select data source - Online
• Step 2: Select target database - select the Offline Migration
  
• The following step is same as a default process

Method#6: JDBC - JDBC

• Begining the migration wizard
• Step 1: Select data source - Online
• Step 2: Select target database - select the Online Migration
  
• The following step is same as a default process