CUBRID Migration Toolkit Getting Started_old

■ Migration way on CUBRID Migration Toolkit

You can export data to use CUBRID Migration Toolkit by followings way.

1. Export data by using connection with JDBC driver (CUBRID, MySQL, Oracle) for a remote migration

2. Export data to use a mysqldump file with the xml export option for MySQL XML dump file migration function

CUBRID Migration Toolkit is also able to import on CUBRID with following ways.

1. Import data with JDBC connection on a target server

2. Import data with converted LoadDB file by using loaddb utility manually

■ Migration senarios

□ Scenario 1: Migrate from JDBC to JDBC

This is a migration way when the source and the target database are on the remote. It is easy to migrate but migration speed is quite slow compare with other migration methods. It may suitable for small size data migration.

□ Scenario 2: Migrate from JDBC to LoadDB

This is a migration way when the source and the target database are on the remote. After complete a migration, you should upload into the server and import by using loaddb utility on CUBRID server. It may so fast and it can be used even if the source database is large scale.

□ Scenario 3: Migrate from MySQL XML dump to LoadDB

It can be used if the source database is MySQL and you can't connect directly this server. MySQL can be exported xml dump file, CUBRID Migration Toolkit can migrate by MySQL dump style's xml file.