CUBRID Migration Toolkit

CUBRID Migration Toolkit (CMT) is a software tool which allows to migrate user data from MySQL/Oracle/MS SQL/CUBRID(previous versions) to CUBRID database server. The data and schema in the source database can be as sofisticated as possible. CMT provides the default settings to cast native MySQL and other DBMS data types to native CUBRID data types, though most of the will overlap as CUBRID provides over 90% MySQL compatibility. If it is necessary to have the destination column data type different from the default settings, it can be easily customized before the migration process starts.

Key features

CMT provides the following key features.

Supports migration of MySQL/Oracle/SQL Server/CUBRID database to CUBRID
Supports offline/online migration
Supports localhost or remote migration
Supports MySQL dump file migration(XML format)
Supports data type mapping configuration
Supports migration history review
Supports automatic table to table, view to view creating
Supports migration script saving and loading
Supports command line style to execute migration script
Supports DDL of creating target table and view saving
Supports migration progress view and migration report
Supports migration error log
Supports timezone data transform
Supports creating new database in offline migration
Supports multi parameters of loaddb command
Supports partition table migration
Supports parallel execution in exporting records
Supports change owner in offline migration
Supports sequence migration
Supports configuration of changing MySQL unparsed time/date/timestamp/datetime value

Downloads

To download CUBRID Migration Tool, visit http://www.cubrid.org/downloads.

Release Note

This release note contains very important information about the changes in CMT version 1.5.0 and above. It provides a list of features available in CMT, as well as the description of the entire migration process. All users are recommended to read the release note.

Wiki: CUBRID Migration Tool Release Notes

Instructions

System Requirements

OS	Memory Size	Disk Space
Windows 32/64 Bit (XP, 2003, Vista, 7)	512 MB or more	500 MB or more for database migration
Linux 32/64 Bit	512 MB or more	500 MB or more for database migration

Software Requirements

JRE 1.5 or above is required. To check which version of Java is installed on your machine or to download the latest version of JRE, see Java installation instructions.

Installation

CMT Installation is very easy. Just extract both archives (CMT Server and CMT Client) to the desired location.

Using CMT

Prepare a source database in MySQL or other DBMS which you would like to migrate to CUBRID.
Start the CMT Server:

Open Command Line Terminal and navigate to the location where the CMT Server has been installed. In my case, I have installed it to C:\cubridmigration_server.
Set CMT_HOME environment variable by typing the following command.
```
			set CMT_HOME=c:\cubridmigration_server
			
```
Start the CMT Server by typing the following command.
```
			cmt_server start
			
```

Start the CMT Client:

Open the directory where the CMT Client has been installed and run the cubridmigration application.
When you launch CMT for the first time, you will be shown the BSD license, which prompts you to agree upon.

For more detailed documentation and guide see the Release Note above.

Support

If you have any difficulties working with CUBRID Migration Toolkit, post your questions to the CUBRID Migration Toolkit forum.