Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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)

  • 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
comments powered by Disqus
Page info
viewed 693 times
translations en
Author
posted 2 years ago by
newpcraft
Contributors
updated 2 years ago by
View revisions
tagged
Share this article