개요

Tibero 에서 Table Migrator 를 실행 전 미리 Table Migrator 의 스크립트를 생성할 수 있는 쿼리 입니다. 

옵션은 아래의 SQL 문을 수정하여 선택적으로 설정할 수 있습니다.

아래 쿼리로 나온 결과 값은 .bat 파일로 만듭니다.

방법

수행

select 'echo TABLE_NAME : ' || table_name || ' Start DateTime : %date% %time% >> mig_log_' || to_char(sysdate, 'YYYYMMDD') || '.text' || chr(13) || chr(10)
|| 'call migrator.bat SOURCE_TYPE=GENERIC SOURCE_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver SOURCE_URL=jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;'
|| 'databaseName=dbname SOURCE_USER=user_name SOURCE_PASSWORD="password" SOURCE_SCHEMA=dbo SOURCE_LOGIN_AS=NORMAL SOURCE_TABLE=' || table_name
|| ' TARGET_TYPE=DEFAULT TARGET_DRIVER=com.tmax.tibero.jdbc.TbDriver TARGET_URL=jdbc:tibero:thin:@xxx.xxx.xxx.xxx:8629:SID TARGET_USER=user_name '
|| 'TARGET_PASSWORD=passoword TARGET_TABLE=' || table_name || ' SELECT_AS_BYTE=N INSERT_METHOD=' ||
( select CASE max(CASE c.data_type
when 'BLOB' then '1' when 'CLOB' then '1' when 'BFILE' then '1' else '0' end )
when '1' then 'CPL' else 'DPL' end
from dba_tab_columns c
where c.table_name = t.table_name and c.owner = t.owner
)
|| ' INSERT_THREAD_COUNT=4 INSERT_COLUMN_NAME_CASE_SENSITIVE=N CHECK_COLUMN_METADATA=N INSERT_ZERO_LENGTH_STRING_AS_NULL=N'
|| ' >> mig_log' || to_char(sysdate, 'YYYYMMDD') || '.text' || chr(13) || chr(10)
|| 'echo END DataTime : %date% %time% >> mig_log_' || to_char(sysdate, 'YYYYMMDD') || '.text' from dba_tables t
where t.owner = 'TIBERO';

수행 결과

echo TABLE_NAME : DR$CTXCATINDEX_BOOK$I Start DateTime : %date% %time% >> mig_log_20251124.text
call migrator.bat SOURCE_TYPE=GENERIC SOURCE_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver SOURCE_URL=jdbc:sq
lserver://xxx.xxx.xxx.xxx:1433;databaseName=dbname SOURCE_USER=user_name SOURCE_PASSWORD="password" SOURCE_SCHEMA=d
bo SOURCE_LOGIN_AS=NORMAL SOURCE_TABLE=DR$CTXCATINDEX_BOOK$I TARGET_TYPE=DEFAULT TARGET_DRIVER=com.tmax.tibero.jdbc
.TbDriver TARGET_URL=jdbc:tibero:thin:@xxx.xxx.xxx.xxx:8629:SID TARGET_USER=user_name TARGET_PASSWORD=passoword TAR
GET_TABLE=DR$CTXCATINDEX_BOOK$I SELECT_AS_BYTE=N INSERT_METHOD=DPL INSERT_THREAD_COUNT=4 INSERT_COLUMN_NAME_CASE_SE
NSITIVE=N CHECK_COLUMN_METADATA=N INSERT_ZERO_LENGTH_STRING_AS_NULL=N >> mig_log20251124.text
echo END DataTime : %date% %time% >> mig_log_20251124.text

echo TABLE_NAME : FRAG_TEST Start DateTime : %date% %time% >> mig_log_20251124.text
call migrator.bat SOURCE_TYPE=GENERIC SOURCE_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver SOURCE_URL=jdbc:sq
lserver://xxx.xxx.xxx.xxx:1433;databaseName=dbname SOURCE_USER=user_name SOURCE_PASSWORD="password" SOURCE_SCHEMA=d
bo SOURCE_LOGIN_AS=NORMAL SOURCE_TABLE=FRAG_TEST TARGET_TYPE=DEFAULT TARGET_DRIVER=com.tmax.tibero.jdbc.TbDriver TA
RGET_URL=jdbc:tibero:thin:@xxx.xxx.xxx.xxx:8629:SID TARGET_USER=user_name TARGET_PASSWORD=passoword TARGET_TABLE=FR
AG_TEST SELECT_AS_BYTE=N INSERT_METHOD=DPL INSERT_THREAD_COUNT=4 INSERT_COLUMN_NAME_CASE_SENSITIVE=N CHECK_COLUMN_M
ETADATA=N INSERT_ZERO_LENGTH_STRING_AS_NULL=N >> mig_log20251124.text
echo END DataTime : %date% %time% >> mig_log_20251124.text