MTK (Migrationtoolkit) 을 사용하기 위해선 java 1.8.0 이상의 버젼과,, edb-jdbc가 필요하다..
dnf install java-11dnf install edb-jdbcdnf install edb-migrationtoolkit
1. 프로퍼티 수정
vi /usr/edb/migrationtoolkit/etc/toolkit.properties
SRC_DB_URL=jdbc:oracle:thin:@172.21.135.17:1521:VIS1226
SRC_DB_USER=lyj
SRC_DB_PASSWORD=1234
TARGET_DB_URL=jdbc:edb://localhost:5444/edb
TARGET_DB_USER=lyj
TARGET_DB_PASSWORD=1234
2. ojdbc 및 edb-jdbc MTK 경로에 업로드
| ll /usr/edb/migrationtoolkit/lib -rwxr-xr-x. 1 root root 587402 Nov 20 06:30 commons-lang3-3.12.0.jar-rwxr-xr-x. 1 root root 227886 Nov 20 06:30 edb-commons.jar lrwxrwxrwx. 1 root root 28 Jan 6 02:42 edb-jdbc18.jar -> /usr/edb/jdbc/edb-jdbc18.jar -rwxr-xr-x. 1 root root 301873 Nov 20 06:30 log4j-api-2.17.1.jar -rwxr-xr-x. 1 root root 1790452 Nov 20 06:30 log4j-core-2.17.1.jar -rw-r--r--. 1 root root 4475293 Jan 6 20:37 ojdbc8.jar |
3. schema 메타 추출 수행
| mkdir -p /usr/edb/migrationtoolkit/lyj /usr/edb/migrationtoolkit/bin/runMTK.sh -schemaOnly -offlineMigration /usr/edb/migrationtoolkit/lyj LYJ #추출 결과 # ll /usr/edb/migrationtoolkit/lyj -rw-r--r--. 1 root root 407 Apr 21 22:37 mtk_lyj_constraint_ddl.sql -rw-r--r--. 1 root root 42928 Apr 21 22:37 mtk_lyj_ddl.sql -rw-r--r--. 1 root root 3403 Apr 21 22:37 mtk_lyj_function_ddl.sql -rw-r--r--. 1 root root 482 Apr 21 22:37 mtk_lyj_index_ddl.sql -rw-r--r--. 1 root root 26 Apr 21 22:37 mtk_lyj_schema_ddl.sql -rw-r--r--. 1 root root 2253 Apr 21 22:37 mtk_lyj_table_ddl.sql -rw-r--r--. 1 root root 36461 Apr 21 22:37 mtk_lyj_view_ddl.sql # EPAS 메타 생성 # psql -d edb -U enterprisedb -p 5444 edb=# \i /usr/edb/migrationtoolkit/lyj/mtk_lyj_schema_ddl.sql edb=# set search_path to lyj; edb=# show search_path; search_path ------------- lyj (1 row) edb=# \i /usr/edb/migrationtoolkit/orange/mtk_lyj_table_ddl.sql SET CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE # ORACLE to EPAS 데이터 이관 # /usr/edb/migrationtoolkit/bin/runMTK.sh -dataOnly lyj Running EnterpriseDB Migration Toolkit (Build 55.10.0) ... Source database connectivity info... conn =jdbc:oracle:thin:@172.21.135.17:1521:VIS1226 user =system password=****** Target database connectivity info... conn =jdbc:edb://localhost:5444/edb user =enterprisedb password=****** Connecting with source Oracle database server... Connected to Oracle, version 'Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options' Connecting with target EDB Postgres database server... Connected to EnterpriseDB, version '17.4.0' Importing redwood schema lyj... Initializing Data Loader 1... Loading Table Data in 8 MB batches... Loading Table: lyj.catalog_version ... … 생략 Schema lyj imported successfully. Migration process completed successfully. Total Elapsed Migration Time (sec): 2.335 Migration logs have been saved to /root/.enterprisedb/migration-toolkit/logs ******************** Migration Summary ******************** Tables: 8 out of 8 Total objects: 8 Successful count: 8 Failed count: 0 Invalid count: 0 ************************************************************* |