Background Image

BLOG

?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print

Written by Rathana Va at Phnom Voar Software, Cambodia

 


Introduction 

CUBRID Migration Toolkit (CMT) Console is a tool to migrate the data and the schema from the source DB (MySQL, Oracle, CUBRID, etc) to the target DB (CUBRID). CMT Console mode is a separate product from the CMT GUI version. It could be useful for some cases like automating migration or linux command line mode.

 


Installation 

  • Windows

1. Download through the link: http://ftp.cubrid.org/CUBRID_Tools/CUBRID_Migration_Toolkit/CUBRID-Migration-Toolkit-11.0-latest-windows-x64.zip

2. Extract the Zip file

  • Linux

1. Download through the link using web browser or wget command: http://ftp.cubrid.org/CUBRID_Tools/CUBRID_Migration_Toolkit/CUBRID-Migration-Toolkit-11.0-latest-linux-x86_64.tar.gz

2. Extract the tar.gz file

tar -xf CUBRID-Migration-Toolkit-11.0-latest-linux-x86_64.tar.gz

 


Using CMT Console

Build Migration Script

It is a feature for exporting the xml script which is used for migrating databases. CMT GUI versions also support this feature.

 

Command Template

  • Windows:

migration.bat script -s <source_configuration> -t <target _configuration> -o <script_file> 
  • Linux:

sh migration.sh script -s <source_configuration>  -t <target _configuration> -o <script_file> 

 

  • source_configuration: It is a configuration name of database source connection.

  • target_configuration: It is a configuration name of data target connection

  • script_file: It is the xml script file name which is going to save after successfully generated.

Open db.conf file which is located inside the CMT console folder, then modify configuration for your database connection. db.conf has prefix configuration names like: db2, db3, db4, mt, demodb. It is just a configuration name when set in command, you can add new or change as for your convenience.

 

Parameters:

  • type: It is a type of database: like MySQL, cubrid …etc.

  • driver: driver file which located in jdbc folder corresponded to type of database, better just leave as default from original db.conf

  • host: IP address of server which database has installed

  • port: Port of database running, for example curbrid running on port 33000 as default.

  • dbname: name of database schema

  • user: username of database

  • password: password of user

  • charset: utf-8

In this example, let pick up mt as source and demodb as target.

Now replace variable in command line to real value.

 

Command Usage

Open terminal or cmd and navigate to the CMT Console folder which you have extracted.

  • Windows

migration.bat script -s mt -t demodb -o script.xml 
  • Linux

sh migration.sh script -s mt -t demodb -o script.xml 

 

After successfully executing, it will generate a script.xml file in the CMT console folder.

 

Migration Database

It is a feature for migrating databases by using xml script.

  • Window

migration.bat start script.xml
  • Linux

sh migration.sh start script.xml

 

After finishing, it shows the results like this.

r/CUBRID - Getting Started with Cubrid Migration Toolkit Console Mode

Finally, we can migrate databases successfully. It will generate a report which is located in the workspace/cmt/report and can be viewed in CMT GUI version.

 


  1. Getting Started with Cubrid Migration Toolkit Console Mode

    Written by Rathana Va at Phnom Voar Software, Cambodia Introduction CUBRID Migration Toolkit (CMT) Console is a tool to migrate the data and the schema from the source DB (MySQL, Oracle, CUBRID, etc) to the target DB (CUBRID). CMT Console mode is a separate product from the CMT GUI version. It could be useful for some cases like automating migration or linux command line mode. Installation Windows 1. Download through the link: http://ftp.cubrid.org/CUBRID_Tools/CUBRID_Migration_Toolkit/CUBRID-Migration-Toolkit-11.0-latest-windows-x64.zip 2. Extract the Zip file ​ Linux 1. Download through the link using web browser or wget command: http://ftp.cubrid.org/CUBRID_Tools/CUBRID_Migration_Toolkit/CUBRID-Migration-Toolkit-11.0-latest-linux-x86_64.tar.gz 2. Extract the tar.gz file ​ tar -xf CUBRID-...
    Read More
  2. Getting Started With DBeaver for CUBRID

    Written by Thim Thorn at Phnom Voar Software, Cambodia Introduction DBeaver is a free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. DBeaver is running on Windows, Mac OS X and Linux. This document summarizes how to get started with DBeaver for CUBRID for Windows users. Installing DBeaver on a Windows To install DBeaver, open a web browser and go to dbeaver.io/download/. Click Windows (Installer) under Community Edition. Follow the instructions on the installation screen. At “Choose Components,” if you already have a Java installed on your ma...
    Read More
Board Pagination Prev 1 2 3 4 5 6 Next
/ 6

Join the CUBRID Project on