金仓数据库迁移工具kdts的使用方法

你是小白兔么？

499人浏览 · 2025-12-30 11:27:05

你是小白兔么？ · 2025-12-30 11:27:05 发布

抖音平台有我的视频讲解，账号：64274955124

整体复制下面内容，到抖音打开：

7.99 复制打开抖音，看看【图图图911的作品】金仓数据库迁移工具KDTS的安装和简单使用金仓数... https://v.douyin.com/o3sQUf7DjlA/ zGI:/ C@h.Ox 07/02

1、上传kdts安装包和jdk到服务器

上传文件的位置可以根据自己习惯随意安排，我一般放在/home/kingbase/install目录

[kingbase@ttt911 install]$ pwd
/home/kingbase/install
[kingbase@ttt911 install]$ ll
总用量 503196
-rw-r--r-- 1 root root 327757087 12月 30 10:31 kdts-plus-bs-V009R001C002.zip
-rw-r--r-- 1 root root 187513052 12月 30 10:31 openjdk-11.0.2_linux-x64_bin.tar.gz
[kingbase@ttt911 install]$

修改kdts安装包和jdk的属主，此步骤为可选项，不修改其实也可以，用root也能使用迁移工具，

本着最小操作权限原则，建议非必要不用root用户操作

[kingbase@ttt911 install]$ exit
注销
[root@ttt911 ~]# cd /home/kingbase/install/
[root@ttt911 install]# ll
总用量 503196
-rw-r--r-- 1 root root 327757087 12月 30 10:31 kdts-plus-bs-V009R001C002.zip
-rw-r--r-- 1 root root 187513052 12月 30 10:31 openjdk-11.0.2_linux-x64_bin.tar.gz
[root@ttt911 install]# chown kingbase:kingbase kdts-plus-bs-V009R001C002.zip openjdk-11.0.2_linux-x64_bin.tar.gz
[root@ttt911 install]# ll
总用量 503196
-rw-r--r-- 1 kingbase kingbase 327757087 12月 30 10:31 kdts-plus-bs-V009R001C002.zip
-rw-r--r-- 1 kingbase kingbase 187513052 12月 30 10:31 openjdk-11.0.2_linux-x64_bin.tar.gz
[root@ttt911 install]#

2、配置jdk

解压

[kingbase@ttt911 install]$ tar -zxvf openjdk-11.0.2_linux-x64_bin.tar.gz
jdk-11.0.2/bin/jaotc
jdk-11.0.2/bin/jar
jdk-11.0.2/bin/jarsigner
........................................................................
jdk-11.0.2/lib/server/libjsig.so
jdk-11.0.2/lib/server/libjvm.so
jdk-11.0.2/lib/src.zip
jdk-11.0.2/lib/tzdb.dat
jdk-11.0.2/release
[kingbase@ttt911 install]$

修改目录名称

[kingbase@ttt911 install]$ mv jdk-11.0.2/  jdk
[kingbase@ttt911 install]$ ll
总用量 503196
drwxr-xr-x 8 kingbase kingbase        96 12月 30 10:58 jdk
-rw-r--r-- 1 kingbase kingbase 327757087 12月 30 10:31 kdts-plus-bs-V009R001C002.zip
-rw-r--r-- 1 kingbase kingbase 187513052 12月 30 10:31 openjdk-11.0.2_linux-x64_bin.tar.gz
[kingbase@ttt911 install]$

3、配置kdts

解压kdts安装包

[kingbase@ttt911 install]$ unzip kdts-plus-bs-V009R001C002.zip
Archive:  kdts-plus-bs-V009R001C002.zip
   creating: kdts-plus-bs-V009R001C002/
   creating: kdts-plus-bs-V009R001C002/bin/
  inflating: kdts-plus-bs-V009R001C002/bin/shutdown.sh
  inflating: kdts-plus-bs-V009R001C002/bin/version.sh
  inflating: kdts-plus-bs-V009R001C002/bin/startup.sh
  inflating: kdts-plus-bs-V009R001C002/bin/version.bat
  inflating: kdts-plus-bs-V009R001C002/bin/shutdown.bat
  inflating: kdts-plus-bs-V009R001C002/bin/startup.bat
.......................................................
  creating: kdts-plus-bs-V009R001C002/doc/
  inflating: kdts-plus-bs-V009R001C002/doc/使用指南.pdf
  inflating: kdts-plus-bs-V009R001C002/doc/Kingbase Data Transformation Service KDTS User Guide.pdf
  inflating: kdts-plus-bs-V009R001C002/doc/金仓数据库数据迁移服务KDTS使用手册.pdf
[kingbase@ttt911 install]$

修改kdts工具startup.sh脚本中JAVA_PATH的路径

将脚本中的JAVA_PATH=${BASE_PATH}"/jdk"替换成实际的JAVA_PATH=/home/kingbase/install/jdk

[kingbase@ttt911 install]$ ll
总用量 503196
drwxr-xr-x  8 kingbase kingbase        96 12月 30 10:58 jdk
drwxr-xr-x 10 kingbase kingbase       100 12月 30 11:08 kdts-plus-bs-V009R001C002
-rw-r--r--  1 kingbase kingbase 327757087 12月 30 10:31 kdts-plus-bs-V009R001C002.zip
-rw-r--r--  1 kingbase kingbase 187513052 12月 30 10:31 openjdk-11.0.2_linux-x64_bin.tar.gz
[kingbase@ttt911 install]$ cd kdts-plus-bs-V009R001C002/bin/
[kingbase@ttt911 bin]$ ll
总用量 36
-rw-r--r-- 1 kingbase kingbase   517  5月 26  2025 shutdown.bat
-rwxr-xr-x 1 kingbase kingbase   348 12月 21  2023 shutdown.sh
-rw-r--r-- 1 kingbase kingbase 10681 10月 29 17:26 startup.bat
-rwxr-xr-x 1 kingbase kingbase  7606 12月 30 11:09 startup.sh
-rw-r--r-- 1 kingbase kingbase   326  3月  7  2025 version.bat
-rwxr-xr-x 1 kingbase kingbase   353  3月  7  2025 version.sh
[kingbase@ttt911 bin]$ vi startup.sh
[kingbase@ttt911 bin]$ cat startup.sh | grep JAVA_PATH=
#JAVA_PATH=${BASE_PATH}"/jdk"
JAVA_PATH=/home/kingbase/install/jdk
    echo "JAVA_PATH=${JAVA_PATH}"
[kingbase@ttt911 bin]$

4、启动kdts迁移工具

[kingbase@ttt911 bin]$ ./startup.sh
------------------------------------------------------------------------
openjdk version "11.0.2" 2019-01-15
OpenJDK Runtime Environment 18.9 (build 11.0.2+9)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.2+9, mixed mode)
------------------------------------------------------------------------
================================================ 2025-12-30_11-13-24 ================================================
kdts-app-console v2.0.2.117
jar name: kdts-app-console-2.0.2.117.jar
base path: /home/kingbase/install/kdts-plus-bs-V009R001C002
bin path: /home/kingbase/install/kdts-plus-bs-V009R001C002/bin
config path: /home/kingbase/install/kdts-plus-bs-V009R001C002/conf
log path: /home/kingbase/install/kdts-plus-bs-V009R001C002/logs/kdts-app-console_2025-12-30_11-13-24.log
java path: /home/kingbase/install/jdk
JAVA_OPT: -server -Dfile.encoding=UTF-8 -Djava.awt.headless=true -Duser.timezone=Asia/ShangHai -Dcache_enable=true -XX:+UnlockExperimentalVMOptions -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -XX:G1NewSizePercent=30 -XX:G1MaxNewSizePercent=50 -XX:+ParallelRefProcEnabled -XX:+AlwaysPreTouch -XX:+UseStringDeduplication -XX:StringDeduplicationAgeThreshold=3 -XX:SurvivorRatio=8 -XX:NewRatio=1 -Dconfig.path=/home/kingbase/install/kdts-plus-bs-V009R001C002/conf -Djavax.xml.parsers.SAXParserFactory=com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl -Djavax.xml.transform.TransformerFactory=com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl -Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl -Djava.security.properties=./conf/enableLegacyTLS.security -Duser.country=CN -Duser.language=zh -Djsse.enableCBCProtection=false --add-opens java.base/jdk.internal.loader=ALL-UNNAMED --add-opens jdk.zipfs/jdk.nio.zipfs=ALL-UNNAMED --add-opens java.base/java.net=ALL-UNNAMED --add-opens java.base/java.lang.invoke=ALL-UNNAMED --add-opens java.base/java.util.concurrent=ALL-UNNAMED -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=./logs/ -Xms1494M -Xmx1494M -XX:+UseG1GC -XX:G1ReservePercent=20 -XX:+UseCompressedOops -XX:+UseCompressedClassPointers -XX:G1HeapRegionSize=8M -XX:+SegmentedCodeCache -XX:+PrintCommandLineFlags -XX:+ExplicitGCInvokesConcurrent
FreeMemory=668M JavaMemory=1494M
cpu_arch=x86_64
startup command: /home/kingbase/install/jdk/bin/java -server -Dfile.encoding=UTF-8 -Djava.awt.headless=true -Duser.timezone=Asia/ShangHai -Dcache_enable=true -XX:+UnlockExperimentalVMOptions -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -XX:G1NewSizePercent=30 -XX:G1MaxNewSizePercent=50 -XX:+ParallelRefProcEnabled -XX:+AlwaysPreTouch -XX:+UseStringDeduplication -XX:StringDeduplicationAgeThreshold=3 -XX:SurvivorRatio=8 -XX:NewRatio=1 -Dconfig.path=/home/kingbase/install/kdts-plus-bs-V009R001C002/conf -Djavax.xml.parsers.SAXParserFactory=com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl -Djavax.xml.transform.TransformerFactory=com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl -Djavax.xml.parsers.DocumentBuilderFactory=com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl -Djava.security.properties=./conf/enableLegacyTLS.security -Duser.country=CN -Duser.language=zh -Djsse.enableCBCProtection=false --add-opens java.base/jdk.internal.loader=ALL-UNNAMED --add-opens jdk.zipfs/jdk.nio.zipfs=ALL-UNNAMED --add-opens java.base/java.net=ALL-UNNAMED --add-opens java.base/java.lang.invoke=ALL-UNNAMED --add-opens java.base/java.util.concurrent=ALL-UNNAMED -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=./logs/ -Xms1494M -Xmx1494M -XX:+UseG1GC -XX:G1ReservePercent=20 -XX:+UseCompressedOops -XX:+UseCompressedClassPointers -XX:G1HeapRegionSize=8M -XX:+SegmentedCodeCache -XX:+PrintCommandLineFlags -XX:+ExplicitGCInvokesConcurrent -jar /home/kingbase/install/kdts-plus-bs-V009R001C002/lib/kdts-app-console-2.0.2.117.jar > /home/kingbase/install/kdts-plus-bs-V009R001C002/logs/kdts-app-console_2025-12-30_11-13-24.log 2>&1 &
application pid: 27350

See "../logs/kdts-app-console_2025-12-30_11-13-24.log" or use the command-line "tail -f ../logs/kdts-app-console_2025-12-30_11-13-24.log" for more detail.
[kingbase@ttt911 bin]$