Overview

This is a query that can generate the Table Migrator script in advance before running Table Migrator in Tibero. 

Options can be selectively set by modifying the SQL statement below.

The result value from the query below is made into a .bat file.

Method

Execution

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';

Execution Result

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