kylin中安装达梦并从oracle迁移到达梦数据库

1.网络安装配置
nmtui 
https://blog.csdn.net/QingTian1024/article/details/143633842

查看网络配置
cat /etc/sysconfig/network-scripts/ifcfg-enp0s3

Diandian123

2.下载docker
https://mirrors.aliyun.com/docker-ce/linux/static/stable/x86_64/?spm=a2c6h.25603864.0.0.362915e8kkd6sc


3.下载达梦数据库
https://www.dameng.com/list_103.html&nbsp


4.安装docker
没有tar命令
https://www.cnblogs.com/hello1123/p/17843843.html
yum install tar
错误:在"/etc/yum.repos.d", "/etc/yum/repos.d", "/etc/distro.repos.d"中没有被启用的仓库


下载阿里云仓库文件
https://mirrors.aliyun.com/repo/

将文件拷贝到了/etc/yum/repos.d




https://blog.csdn.net/weixin_43332972/article/details/141164651
cd /docker
tar -xzf docker-20.10.19.tgz
 
 
移动解压后的全部内容到/usr/bin/下
 
mv docker/* /usr/bin/


1.编辑docker.service文件
 
vi /usr/lib/systemd/system/docker.service
 
[Unit] 
Description=Docker Application Container Engine 
Documentation=https://docs.docker.com 
After=network-online.target firewalld.service 
Wants=network-online.target
 
 
[Service] 
Type=notify 
ExecStart=/usr/bin/dockerd 
ExecReload=/bin/kill -s HUP $MAINPID 
LimitNOFILE=infinity 
LimitNPROC=infinity 
TimeoutStartSec=0 
Delegate=yes 
KillMode=process 
Restart=on-failure 
StartLimitBurst=3 
StartLimitInterval=60s
 
 
[Install] 
WantedBy=multi-user.target
 
 
 
2.添加docker.service文件的权限
chmod +x /usr/lib/systemd/system/docker.service
 
 
 
3. 创建daemon.json文件
 
mkdir /etc/docker

touch /etc/docker/daemon.json

tee > daemon.json << EOF
{
  "registry-mirrors": ["https://registry.docker-cn.com"],
  "exec-opts": ["native.cgroupdriver=systemd"]
}
EOF
 
 
 4.加载启动
systemctl daemon-reload;
systemctl start docker;
systemctl enable docker


https://eco.dameng.com/download/
加载达梦docker镜像
docker load -i dm8_20241022_x86_rh6_64_single.tar


达梦dockerfile
https://www.cnblogs.com/suhai/p/18399575

请自行前往官网下载达梦镜像包: 达梦下载中心
注意:docker启动命令中,镜像名需要按照实际下载的达梦镜像版本替换
达梦数据库镜像的默认账户密码: SYSDBA/SYSDBA001


docker run -d -p 5236:5236 --name dmdb \
--restart=always --privileged=true \
-e LD_LIBRARY_PATH=/opt/dmdbms/bin \
-e PAGE_SIZE=32 \
-e EXTENT_SIZE=32 \
-e LOG_SIZE=2048 \
-e UNICODE_FLAG=1 \
-e INSTANCE_NAME=DMSERVER \
-v /data/dmdbms:/opt/dmdbms/data \
dm8_single:dm8_20241022_rev244896_x86_rh6_64


达梦数据库初始化参数(环境变量)
不可修改的参数

PAGE_SIZE:数据文件使用的页大小,单位KB,缺省值8。官方建议生产环境32
EXTENT_SIZE:数据文件中一个簇包含多少页,缺省值16。官方建议生产环境32
LOG_SIZE:重做日志文件大小,单位MB,缺省值256。官方建议生产环境2048
CASE_SENSITIVE:大小写敏感,敏感1,不敏感0,缺省值1。根据实际情况选择,个人推荐保持默认
UNICODE_FLAG:字符集选项,0代表GB18030,1代表UTF-8,2代表韩文字符集EUC-KR,缺省值0。根据实际情况选择,个人推荐1,搭配LENGTH_IN_CHAR参数使用
LENGTH_IN_CHAR:varchar/char类型的长度是否以字符为单位,0表示varchar/char类型的字段长度以字节为单位,1表示varchar/char类型的字段长度以字符为单位,缺省值0。根据实际情况选择,个人推荐1,搭配UNICODE_FLAG参数使用
知识连接:达梦数据库汉字存储知多少
注意:2024年2季度以后版本不再支持该参数。迁移数据时可以通过扩展列长度,或者在表结构中指定字符存储
BLANK_PAD_MODE:字符串比较时,结尾空格填充模式是否兼容Oracle,1兼容,0不兼容,缺省值0。根据实际情况选择,若源数据库非Oracle,建议保持默认
PORT_NUM:初始化时设置dm.ini中的监听端口号,缺省值5236。官方建议生产环境保持默认
初始化后仍可修改的参数

LD_LIBRARY_PATH:当在使用 DM 的驱动(如 unixodbc、dci、dpi、php_dm、pdo_dm 等)时可能需要依赖部分 DM 提供的动态链接库文件,用户需要设置系统环境变量 LD_LIBRARY_PATH,将 DM 数据库的执行码路径添加进去。
知识链接:LD_LIBRARY_PATH 如何设置?
INSTANCE_NAME:初始化数据库实例名称,缺省值"DMSERVER"。官方建议生产环境保持默认
SYSDBA_PWD:初始化实例时设置SYSDBA的密码,缺省值SYSDBA001。根据实际情况选择
LOG_SIZE:日志文件大小,单位MB,缺省值256。根据实际情况选择,个人推荐保持默认
BUFFER:系统缓存大小,单位MB,缺省值1000。根据实际情况选择,个人推荐保持默认


下载达梦连接工具
https://dbeaver.io/download/



下载达梦驱动
https://eco.dameng.com/download/




创建迁移评估报告


创建迁移工程


-- 查看oracle版本
SELECT * FROM v$versio;


--  查看表空间使用大小
SELECT
    df.tablespace_name,
    ROUND(SUM(df.bytes) / 1024 / 1024, 2) AS "Total_MB",
    ROUND(SUM(df.maxbytes) / 1024 / 1024, 2) AS "Max_MB",
    ROUND(SUM(df.bytes) / SUM(NVL(fs.bytes, 0)) * 100, 2) AS "Used_Percent"
FROM
    dba_data_files df
    LEFT JOIN (SELECT
                   tablespace_name,
                   file_id,
                   SUM(bytes) bytes
               FROM
                   dba_free_space
               GROUP BY
                   tablespace_name,
                   file_id
           ) fs ON df.tablespace_name = fs.tablespace_name
           AND df.file_id = fs.file_id
GROUP BY
    df.tablespace_name;

-- 查看表空间
SELECT tablespace_name, file_name, bytes/1024/1024 AS size_mb, autoextensible FROM dba_data_files;

-- 查看需要迁移的对象
select object_type,count(*) from dba_objects where owner='FIRE' group by object_type;

-- 查看字符集
select userenv('language') from dual;


-- 创建临时表空间
-- 在达梦中是失败的
CREATE TEMPORARY TABLESPACE FIRE_TEMP TEMPFILE '/opt/dmdbms/data/DAMENG/FIRE_TEMP.DBF' SIZE 1024M AUTOEXTEND ON NEXT 128M MAXSIZE 2048M;


-- 创建表空间
CREATE  CONTENTS PERMANENT TABLESPACE FIRE_TP BLOCKSIZE 8192 INITIAL 65536K MINEXTENTS 1 MAXEXTENTS 2147483645 MINEXTLEN 65536K STATUS ONLINE LOGGING LOGGING FORCE LOGGING NO EXTENT MANAGEMENT LOCAL ALLOCATION TYPE SYSTEM PLUGGED IN NO SEGMENT SPACE MANAGEMENT AUTO DEFAULT TABLE COMPRESSION DISABLED RETENTION NOT_APPLY;


-- 达梦表空间查询
SELECT a.tablespace_name "表空间名称",
total / (1024 * 1024) "表空间大小(M)",
free / (1024 * 1024) "表空间剩余大小(M)",
(total - free) / (1024 * 1024 ) "表空间使用大小(M)",
total / (1024 * 1024 * 1024) "表空间大小(G)",
free / (1024 * 1024 * 1024) "表空间剩余大小(G)",
(total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)",
round((total - free) / total, 4) * 100 "使用率 %"
FROM (SELECT tablespace_name, SUM(bytes) free
FROM dba_free_space
GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM(bytes) total
FROM dba_data_files
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name;


参考 创建表空间和用户
https://blog.csdn.net/m0_69815481/article/details/140822145


官方迁移
https://eco.dameng.com/document/dm/zh-cn/start/oracle_dm

-- 达梦创建表空间
create tablespace "FIRE_TP" datafile '/opt/dmdbms/data/DAMENG/DATA_FILE01.DBF' size 30720 CACHE = NORMAL;

-- 添加数据文件
alter tablespace "FIRE_TP" add datafile '/opt/dmdbms/data/DAMENG/DATA_FILE02.DBF' size 20480 autoextend on maxsize 67108863;

-- 创建用户 密码长度有要求
CREATE USER "fire" IDENTIFIED BY "Fire123456" HASH WITH SHA512 SALT ENCRYPT BY "123456" DEFAULT TABLESPACE "FIRE_TP" DEFAULT INDEX TABLESPACE "FIRE_TP";


-- 授权
GRANT "DBA","PUBLIC","RESOURCE","SOI" TO "fire";


注:授权有 DBA,PUBLIC,RESOURCE,SOI,SVI,VIT ;

1. DBA(Database Administrator)

定义:DBA是数据库管理员的缩写,具备数据库中的最高级别权限。
权限内容:DBA几乎拥有创建数据库的所有权限,包括创建新的数据库、管理用户权限、备份和恢复数据库、监控和优化数据库性能、管理数据库的安全性和完整性等。DBA可以创建数据库实例、数据库表、数据库对象等,并管理所有用户和他们的权限。
作用:DBA是数据库系统的核心管理者,负责确保数据库的正常运行和安全性。
2. PUBLIC

定义:PUBLIC是一个特殊的角色,它代表数据库中的所有用户。
权限内容:PUBLIC角色具有一些基本的、默认的权限,主要是对自己模式下操作数据的权限。但需要注意的是,PUBLIC角色本身并不直接授予用户创建数据库对象或执行高级管理操作的权限。
作用:PUBLIC角色提供了一种统一的管理方式,使得数据库管理员可以为所有用户设置一些基本的、共通的权限。
3. RESOURCE

定义:RESOURCE是一个预定义的角色,用于管理数据库对象。
权限内容:RESOURCE角色具有在自己模式下创建表、视图等对象的权限,也具有操作自己模式下对象数据的权限。但是,它不能创建数据库结构,如数据库实例或数据库本身。
作用:RESOURCE角色为普通用户提供了在数据库中进行日常操作所需的权限,如数据录入、查询等。
4. SOI(System Object Inspector)

定义:SOI是一个特殊的角色,用于查询系统表。
权限内容:SOI角色具有查询系统表(通常是SYS开头的表)的权限。这些系统表包含了数据库的元数据信息,如数据库结构、对象定义等。
作用:SOI角色允许用户查询数据库的元数据信息,有助于了解数据库的结构和对象定义。
5. SVI 和 VIT

注意:在达梦数据库的官方文档和常见资料中,SVI和VIT并不是标准的预定义角色。这可能是因为它们是在特定环境或版本中自定义的角色,或者是用户误将其他角色名称(如VTI)与SVI和VIT混淆。
建议:如果SVI和VIT是在您的数据库环境中自定义的角色,那么它们的权限将取决于创建这些角色时所赋予的权限。建议查阅相关的数据库角色配置文档或联系数据库管理员以获取准确信息。
6. VTI(View Table Inspector)

定义(基于您提到的可能混淆):虽然VTI不是达梦数据库的标准预定义角色,但根据一些资料,它可能代表具有查询动态视图相关权限的角色。
权限内容:如果VTI确实存在且代表这样的角色,那么它将具有查询系统动态视图的权限。动态视图通常包含数据库的实时状态信息,如性能统计、执行计划等。
作用:VTI角色允许用户查询数据库的实时状态信息,有助于进行性能调优和故障排查。
综上所述,DBA、PUBLIC、RESOURCE和SOI是达梦数据库中常见的预定义角色,它们各自具有不同的权限和作用。而SVI和VIT可能是特定环境或版本中的自定义角色,或者是其他角色的误称。对于VTI角色,虽然它不是标准预定义角色,但根据描述可能代表具有查询动态视图权限的角色。

                        


★尝试直接在kylin中安装达梦数据库
https://eco.dameng.com/document/dm/zh-cn/pm/install-uninstall.html






1. 创建安装用户组 dinstall。
groupadd -g 12349 dinstall
2. 创建安装用户 dmdba。
useradd -u 12345 -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
3. 初始化用户密码。
passwd dmdba
4. 之后通过系统提示进行密码设置。
Fire147258

命令行安装
./DMInstall.bin -i

使用root执行
/home/dmdba/dmdbms/script/root/root_installer.sh



安装完成初始化
https://eco.dameng.com/document/dm/zh-cn/pm/view-dminit-parameters.html

 ./dminit PATH=/home/dmdba/dmdbms/data CHARSET=1 DB_NAME=DMSERVER INSTANCE_NAME=DMSERVER PORT_NUM=6236

 ./dminit PATH=/home/dmdba/dmdbms/data CHARSET=1 PORT_NUM=6236 SYSDBA_PWD=Dmserver123

-- 改变了端口和密码 需要指定
 ./disql sysdba/Dmserver123@localhost:6236

-- 防火墙开放端口
 firewall-cmd --permanent --add-port=6236/tcp

 firewall-cmd --reload

 firewall-cmd --list-ports



-- 例子:
 ./dminit PATH=/dmdata/data PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=y
CHARSET=1 DB_NAME=DMTEST INSTANCE_NAME=DBSERVER PORT_NUM=5237

select * from V$DM_INI 


-- 前台方式启动数据库 启动界面会话关闭数据库也相应会关闭
dmdba 用户使用前台的方式启动数据库,进入 DM 安装目录下的 bin 目录下,命令如下:
./dmserver /home/dmdba/dmdbms/data/DAMENG/dm.ini



执行脚本
https://eco.dameng.com/document/dm/zh-cn/pm/dm8_linux-script-manual.html

-- 注册服务
./dm_service_installer.sh -t dmserver -dm_ini /home/dmdba/dmdbms/data/DAMENG/dm.ini -p DMSERVER


-- 卸载服务
./dm_service_uninstaller.sh -n DmServiceDMSERVER

-- systemctl方式安装成服务 创建系统服务配置文件(/usr/lib/systemd/system/DmServiceDMSERVER.service)
[Unit]
Description=DmServiceDMSERVER
After=network.target remote-fs.target

[Service]
Type=forking
PIDFile=/home/dmdba/dmdbms/bin/pids/DmServiceDMSERVER.pid
ExecStart=/home/dmdba/dmdbms/bin/DmServiceDMSERVER start
ExecStop=/home/dmdba/dmdbms/bin/DmServiceDMSERVER stop
PrivateTmp=true

[Install]
WantedBy=multi-user.target






##执行卸载脚本命令行卸载需要添加参数-i
./uninstall.sh -i



-- 配置jdk
~/.bash_profile

export JAVA_HOME=/home/dmdba/jdk1.8.0_431
export CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$PATH:$JAVA_HOME/bin

6.使配置立即生效
 source ~/.bash_profile





xhost命令无效
-- 查看是哪些提供了 */xhost
yum whatprovides "*/xhost"     

yum -y install xorg-x11-server-utils-7.7-2.el6.x86_64



-- 本地方式测试迁移

使用dmdba用户



-- 达梦创建表空间
create tablespace "FIRE_TP" datafile '/home/dmdba/dmdbms/data/DAMENG/DATA_FILE01.DBF' size 10240 CACHE = NORMAL;

-- 添加数据文件
alter tablespace "FIRE_TP" add datafile '/home/dmdba/dmdbms/data/DAMENG/DATA_FILE02.DBF' size 20480 autoextend on maxsize 67108863;

-- 创建用户 密码长度有要求
CREATE USER "fire" IDENTIFIED BY "Fire123456" HASH WITH SHA512 SALT ENCRYPT BY "123456" DEFAULT TABLESPACE "FIRE_TP" DEFAULT INDEX TABLESPACE "FIRE_TP";


-- 授权
GRANT "DBA","PUBLIC","RESOURCE","SOI" TO "fire";



-- 拷贝到1.xml
<?xml version="1.0" encoding="UTF-8"?>

<!--本文件由DM数据迁移工具生成,请不要手工修改,生成时间2024-12-02 11:40:51.-->
<TransformTask transform="11" name="helowin到dm">
  <Source type="db" useCustomDriver="false" useDefaultURL="true">
    <Server>192.168.1.117</Server>
    <Port>1521</Port>
    <DatabaseVersion>5</DatabaseVersion>
    <AuthType>0</AuthType>
    <Compress>false</Compress>
    <User>fire</User>
    <Password>****</Password>
    <Service>helowin</Service>
  </Source>
  <Destination type="db" useCustomDriver="false" useDefaultURL="true">
    <Server>192.168.1.17</Server>
    <Port>6236</Port>
    <AuthType>0</AuthType>
    <Compress>false</Compress>
    <DmType>dm</DmType>
    <User>fire</User>
    <Password>********</Password>
  </Destination>
  <Config selectObjType="1">
    <Strategy name="lengthInChar" value="1.0"/>
    <Strategy name="continueWhenError" value="true"/>
    <Strategy name="threadCount" value="2"/>
    <Strategy name="objectNameToUpperCase" value="true"/>
  </Config>
  <Mode simple="false" oracleSynonymTableOwner="0">
    <DBStrategies>
      <Strategy>TRANSFORM_SCHEMAS</Strategy>
    </DBStrategies>
    <Schema source="FIRE" destination="FIRE">
      <Strategies>
        <Strategy name="schObjectStrategys" value="TRANSFORM_TABLES,TRANSFORM_VIEWS,TRANSFORM_MVIEWS,TRANSFORM_SEQUENCES,TRANSFORM_PROCEDURE_FUNCTIONS,TRANSFORM_DATABASE_AND_SCHEMA_TRIGGERS,TRANSFORM_PACKAGES,TRANSFORM_SYNONYM,TRANSFORM_TYPES"/>
      </Strategies>
    </Schema>
  </Mode>
  <TransformItems ItemCount="250">
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="GC" destination="GC" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="GONGHUODAN" destination="GONGHUODAN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="MYLAKE" destination="MYLAKE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ABNORMAL" destination="T_ABNORMAL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ABNORMALDATE" destination="T_ABNORMALDATE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ABNORMAL_USER" destination="T_ABNORMAL_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ADMIN" destination="T_ADMIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ALLDUTYHEADQUARTERS" destination="T_ALLDUTYHEADQUARTERS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_APPLY_AREA" destination="T_APPLY_AREA" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_APPONECALL_INFO" destination="T_APPONECALL_INFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_APP_CRASH" destination="T_APP_CRASH" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AREA" destination="T_AREA" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ASSESS_SIGN_ITEM" destination="T_ASSESS_SIGN_ITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTEND_CARINFO" destination="T_ATTEND_CARINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTEND_FORCE" destination="T_ATTEND_FORCE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTEND_GROUP" destination="T_ATTEND_GROUP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTEND_GROUPMISSION" destination="T_ATTEND_GROUPMISSION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTEND_HANDOVERINFO" destination="T_ATTEND_HANDOVERINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTEND_STAFFINFO" destination="T_ATTEND_STAFFINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTRIBUTE" destination="T_ATTRIBUTE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ATTRIBUTE_CATEGORY" destination="T_ATTRIBUTE_CATEGORY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUDIT_ORG" destination="T_AUDIT_ORG" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUDIT_PROJECT" destination="T_AUDIT_PROJECT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUDIT_REPORT" destination="T_AUDIT_REPORT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUDIT_UNIT" destination="T_AUDIT_UNIT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUTHORITY" destination="T_AUTHORITY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUTHORITY_ROLE" destination="T_AUTHORITY_ROLE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_AUTHORITY_USER" destination="T_AUTHORITY_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_BALANCE" destination="T_BALANCE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_BALANCE_RECORD" destination="T_BALANCE_RECORD" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_BANKELECTRICBILL" destination="T_BANKELECTRICBILL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_BUILDING_MAP" destination="T_BUILDING_MAP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CARD" destination="T_CARD" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CATEGORY" destination="T_CATEGORY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CHANGE_ITEM_LOG" destination="T_CHANGE_ITEM_LOG" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CHARGESCOLLECTABLE" destination="T_CHARGESCOLLECTABLE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CHARGESCOLLECTABLEPRICE" destination="T_CHARGESCOLLECTABLEPRICE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CHECK" destination="T_CHECK" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CHECK_DETAIL" destination="T_CHECK_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_COMBAT_FORMATION" destination="T_COMBAT_FORMATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_COMBAT_FORMATION_ITEM" destination="T_COMBAT_FORMATION_ITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_COMPANY" destination="T_COMPANY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CONTROL" destination="T_CONTROL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CONTROLWATCH" destination="T_CONTROLWATCH" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CONTROLWATCHCHANGE" destination="T_CONTROLWATCHCHANGE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_CONTROL_STAFF" destination="T_CONTROL_STAFF" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DANGERSOURCE" destination="T_DANGERSOURCE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DATABACK" destination="T_DATABACK" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DEFINED" destination="T_DEFINED" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DETECTION" destination="T_DETECTION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DICTIONARIES" destination="T_DICTIONARIES" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DICTIONARIES_TYPE" destination="T_DICTIONARIES_TYPE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DISASTER_CLASSIFY" destination="T_DISASTER_CLASSIFY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DISASTER_GRADE" destination="T_DISASTER_GRADE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DISASTER_GRADE_SUB" destination="T_DISASTER_GRADE_SUB" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DISPATCH_FORCE" destination="T_DISPATCH_FORCE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_DOCUMENT" destination="T_DOCUMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ENROLL" destination="T_ENROLL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT" destination="T_EQUIPMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT_CATEGORIES" destination="T_EQUIPMENT_CATEGORIES" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT_DELETE" destination="T_EQUIPMENT_DELETE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT_MASTER" destination="T_EQUIPMENT_MASTER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT_POSITION_RELATE" destination="T_EQUIPMENT_POSITION_RELATE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT_TYPE" destination="T_EQUIPMENT_TYPE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_EQUIPMENT_USER" destination="T_EQUIPMENT_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ESTIMATE" destination="T_ESTIMATE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ESTIMATE_ARI" destination="T_ESTIMATE_ARI" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FACE_LOG" destination="T_FACE_LOG" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FACE_PERSON" destination="T_FACE_PERSON" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FEEDBACK" destination="T_FEEDBACK" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIGHTCOMMANDCENTER" destination="T_FIGHTCOMMANDCENTER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE" destination="T_FIRE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREEVENTINFO" destination="T_FIREEVENTINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREHOUSE" destination="T_FIREHOUSE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREHOUSE_STAFF" destination="T_FIREHOUSE_STAFF" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREMANSUPERVISE" destination="T_FIREMANSUPERVISE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREMANSUPERVISEDETAIL" destination="T_FIREMANSUPERVISEDETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREMICROSTATION" destination="T_FIREMICROSTATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREMICROSTATION_EQUIPMENT" destination="T_FIREMICROSTATION_EQUIPMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREMICROSTATION_STAFF" destination="T_FIREMICROSTATION_STAFF" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREPIPEPRESSUREDEV" destination="T_FIREPIPEPRESSUREDEV" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIREPIPEPRESSUREINFO" destination="T_FIREPIPEPRESSUREINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_EQUIPMENT_CATEGORY" destination="T_FIRE_EQUIPMENT_CATEGORY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_EQUIPMENT_CLASS" destination="T_FIRE_EQUIPMENT_CLASS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_EQUIPMENT_CODE" destination="T_FIRE_EQUIPMENT_CODE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_TRUCK_ATTR" destination="T_FIRE_TRUCK_ATTR" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_TRUCK_SUBCLASS" destination="T_FIRE_TRUCK_SUBCLASS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_TRUCK_VS_ATTR" destination="T_FIRE_TRUCK_VS_ATTR" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_FIRE_USER_ITEM" destination="T_FIRE_USER_ITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_GENRE" destination="T_GENRE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_GUIDE" destination="T_GUIDE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_GUIDE_TYPE" destination="T_GUIDE_TYPE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_HEADQUARTERS" destination="T_HEADQUARTERS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_INSPECTION" destination="T_INSPECTION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_INSPECTION_DETAIL" destination="T_INSPECTION_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_INSPECTION_REPORT" destination="T_INSPECTION_REPORT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_INSPECTION_STEP" destination="T_INSPECTION_STEP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_IN_ATTACK" destination="T_IN_ATTACK" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM" destination="T_ITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEMACTIVATE" destination="T_ITEMACTIVATE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEMEFFECTIVE" destination="T_ITEMEFFECTIVE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEMEXTENDINFO" destination="T_ITEMEXTENDINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEMKEYSITE" destination="T_ITEMKEYSITE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEMWARNINGINFO" destination="T_ITEMWARNINGINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_ATTRIBUTE" destination="T_ITEM_ATTRIBUTE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_CHANGE" destination="T_ITEM_CHANGE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_DETECTION" destination="T_ITEM_DETECTION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_DEVICE_CHECK" destination="T_ITEM_DEVICE_CHECK" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_MAINTAIN" destination="T_ITEM_MAINTAIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_MAINTAIN_CONTENT" destination="T_ITEM_MAINTAIN_CONTENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_MAP" destination="T_ITEM_MAP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_SOURCE_DANGER_INFO" destination="T_ITEM_SOURCE_DANGER_INFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_STAFF" destination="T_ITEM_STAFF" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_THREE" destination="T_ITEM_THREE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_USEFIRE" destination="T_ITEM_USEFIRE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ITEM_USER" destination="T_ITEM_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_KEYSITE" destination="T_KEYSITE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_LEGAL" destination="T_LEGAL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_LOG" destination="T_LOG" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MAINTAIN" destination="T_MAINTAIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MAINTAIN_CONTENT" destination="T_MAINTAIN_CONTENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MAINTENANCE" destination="T_MAINTENANCE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MAINTENANCEPLAN" destination="T_MAINTENANCEPLAN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MAINTENANCE_INFO" destination="T_MAINTENANCE_INFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MAJOR_JOB" destination="T_MAJOR_JOB" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MANAGEMENT" destination="T_MANAGEMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MANANGEDEP" destination="T_MANANGEDEP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MANANGEDEPITEM" destination="T_MANANGEDEPITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MEETING" destination="T_MEETING" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MESSAGERECORD" destination="T_MESSAGERECORD" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_MONITORDATA" destination="T_MONITORDATA" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_NOTICE" destination="T_NOTICE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_NOTICE_DETAIL" destination="T_NOTICE_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_NOTICE_DETAIL_RECEIPT" destination="T_NOTICE_DETAIL_RECEIPT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_NOTIFICATION" destination="T_NOTIFICATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_OPENING_FIRECHECK" destination="T_OPENING_FIRECHECK" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_OPENING_TMP" destination="T_OPENING_TMP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_OPTION_DICT" destination="T_OPTION_DICT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_PLAN" destination="T_PLAN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_PLANDETAIL" destination="T_PLANDETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_POSITION" destination="T_POSITION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_POSITION_MAP" destination="T_POSITION_MAP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_PROCESSION" destination="T_PROCESSION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_PROCESSION_STAFF" destination="T_PROCESSION_STAFF" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_PROGRAM" destination="T_PROGRAM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_PROGRAM_ANNEX" destination="T_PROGRAM_ANNEX" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECALARMINFO" destination="T_RECALARMINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECALARMINFO_CHANGE" destination="T_RECALARMINFO_CHANGE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECALARMINFO_CHANGE_CONFIRM" destination="T_RECALARMINFO_CHANGE_CONFIRM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECALARMINFO_SQUADRON" destination="T_RECALARMINFO_SQUADRON" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECALARM_OPT" destination="T_RECALARM_OPT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECALARM_THREE" destination="T_RECALARM_THREE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECTIFICATION" destination="T_RECTIFICATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECTIFYNOTICE" destination="T_RECTIFYNOTICE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECTIFYNOTICE_DETAIL" destination="T_RECTIFYNOTICE_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RECTIFYNOTICE_DETAIL_RECEIPT" destination="T_RECTIFYNOTICE_DETAIL_RECEIPT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_REFUND" destination="T_REFUND" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_REMOTE_MONITOR_EQUIPMENT" destination="T_REMOTE_MONITOR_EQUIPMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_REPORTDATE" destination="T_REPORTDATE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_REPORTDATETEST" destination="T_REPORTDATETEST" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_ASERVICE" destination="T_RESCUE_ASERVICE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_BRIGADE" destination="T_RESCUE_BRIGADE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_EXPERTS" destination="T_RESCUE_EXPERTS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_ICONS" destination="T_RESCUE_ICONS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_LOGISTICUNIT" destination="T_RESCUE_LOGISTICUNIT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_MATERIAL" destination="T_RESCUE_MATERIAL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESCUE_STATION" destination="T_RESCUE_STATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESERVE_DETAIL" destination="T_RESERVE_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESERVE_MAIN" destination="T_RESERVE_MAIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RESERVE_PRE" destination="T_RESERVE_PRE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ROLE" destination="T_ROLE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ROLE_AUTHORITY" destination="T_ROLE_AUTHORITY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_ROLE_USER" destination="T_ROLE_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_RULES" destination="T_RULES" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SCHEME" destination="T_SCHEME" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SCHEME_STUDY" destination="T_SCHEME_STUDY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SELECTED_EQUIPMENT" destination="T_SELECTED_EQUIPMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SENSORO_SMOKE" destination="T_SENSORO_SMOKE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SERVERMESSAGE" destination="T_SERVERMESSAGE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SMS" destination="T_SMS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SMSCONFIG" destination="T_SMSCONFIG" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SOURCE_DANGER" destination="T_SOURCE_DANGER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SOURCE_DANGER_INFO" destination="T_SOURCE_DANGER_INFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SOURCE_DANGER_TEMPLATE" destination="T_SOURCE_DANGER_TEMPLATE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SPECIAL_EVENTS" destination="T_SPECIAL_EVENTS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SQUADRON" destination="T_SQUADRON" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SQUADRON_ITEM" destination="T_SQUADRON_ITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SQU_ORBIT" destination="T_SQU_ORBIT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_STAFF" destination="T_STAFF" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_STAFF_ANNEX" destination="T_STAFF_ANNEX" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_STAFF_FIRE" destination="T_STAFF_FIRE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_STAFF_USER" destination="T_STAFF_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_STATION" destination="T_STATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SUPERVISOR_CHECK_INSPECTION" destination="T_SUPERVISOR_CHECK_INSPECTION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_SUPERVISOR_CHK_INSP_DETAIL" destination="T_SUPERVISOR_CHK_INSP_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_THIRDASSESSAUTH" destination="T_THIRDASSESSAUTH" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_THIRDDETECTION" destination="T_THIRDDETECTION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_THIRDDETECTIONAPPLY" destination="T_THIRDDETECTIONAPPLY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_THIRD_ASSESS" destination="T_THIRD_ASSESS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_TMPEQUIPMENT" destination="T_TMPEQUIPMENT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_TMP_INSPECTION_DETAIL" destination="T_TMP_INSPECTION_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_TRAIN" destination="T_TRAIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_TYPESCHEME" destination="T_TYPESCHEME" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_UKEY" destination="T_UKEY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER" destination="T_USER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_ADMIN" destination="T_USER_ADMIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_ALLDUTYHEADQUARTERS" destination="T_USER_ALLDUTYHEADQUARTERS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_AUTHORITY" destination="T_USER_AUTHORITY" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_FIGHTCOMMANDCENTER" destination="T_USER_FIGHTCOMMANDCENTER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_FIRE" destination="T_USER_FIRE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_FLOWCODE" destination="T_USER_FLOWCODE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_HEADQUARTERS" destination="T_USER_HEADQUARTERS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_ITEM" destination="T_USER_ITEM" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_SQUADRON" destination="T_USER_SQUADRON" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_STATION" destination="T_USER_STATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_THIRD" destination="T_USER_THIRD" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_THIRDDETECTION" destination="T_USER_THIRDDETECTION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_USER_WX" destination="T_USER_WX" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WARNING_INFO_PUSH" destination="T_WARNING_INFO_PUSH" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WAR_SIMULATION" destination="T_WAR_SIMULATION" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WATERINFOLIST" destination="T_WATERINFOLIST" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WATERS_ATTR" destination="T_WATERS_ATTR" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WATERS_INFO" destination="T_WATERS_INFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WATERS_IUA" destination="T_WATERS_IUA" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_WATERS_TYPE" destination="T_WATERS_TYPE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_XD_DEVICE" destination="T_XD_DEVICE" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_XFACCOUNT" destination="T_XFACCOUNT" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_XFAREADOMAIN" destination="T_XFAREADOMAIN" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="table" sourceSchema="FIRE" destSchema="FIRE" source="T_XFSETUP" destination="T_XFSETUP" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
    <TransformItem id="0" type="sequence" sourceSchema="FIRE" destSchema="FIRE" source="SEQ_FIRE" destination="SEQ_FIRE" isDefinitionAutoGenerated="true" customColumnMap="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="PRO_REFRESHABNORMAL" destination="PRO_REFRESHABNORMAL" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="SP_ROLE_AUTHORITY" destination="SP_ROLE_AUTHORITY" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="SP_REST_CARD22" destination="SP_REST_CARD22" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="SP_INIT_ITEMEFFECTIVE" destination="SP_INIT_ITEMEFFECTIVE" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="PRO_REFRESHREPORT" destination="PRO_REFRESHREPORT" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="PRO_REFRESHITEMWARNINGINFO2" destination="PRO_REFRESHITEMWARNINGINFO2" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="PRO_REFRESHITEMWARNINGINFO" destination="PRO_REFRESHITEMWARNINGINFO" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="procedure" sourceSchema="FIRE" destSchema="FIRE" source="SP_ROLE_AUTHORITY2" destination="SP_ROLE_AUTHORITY2" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="MY_TO_NUMBER" destination="MY_TO_NUMBER" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="MY_TO_DATE" destination="MY_TO_DATE" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="GETEQUIPMENTINSPECTIONSTATE" destination="GETEQUIPMENTINSPECTIONSTATE" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="GETEQUIPMENTINSPECTIONCYCLE" destination="GETEQUIPMENTINSPECTIONCYCLE" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="FN_QUERYITEMUSESITUATIONINFO2" destination="FN_QUERYITEMUSESITUATIONINFO2" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="FN_QUERYITEMUSESITUATIONINFO" destination="FN_QUERYITEMUSESITUATIONINFO" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="function" sourceSchema="FIRE" destSchema="FIRE" source="FN_GETMANAGERITEMSQLTABLE" destination="FN_GETMANAGERITEMSQLTABLE" isDefinitionAutoGenerated="true" customColumnMap="false" isExternal="false"/>
    <TransformItem id="0" type="type" sourceSchema="FIRE" destSchema="FIRE" source="MANAGERITEM_RECORD" destination="MANAGERITEM_RECORD" isDefinitionAutoGenerated="true" customColumnMap="false" isBodyDefinitionAutoGenerated="true"/>
    <TransformItem id="0" type="type" sourceSchema="FIRE" destSchema="FIRE" source="MANAGERITEM_TABLE" destination="MANAGERITEM_TABLE" isDefinitionAutoGenerated="true" customColumnMap="false" isBodyDefinitionAutoGenerated="true"/>
    <TransformItem id="0" type="type" sourceSchema="FIRE" destSchema="FIRE" source="USESITUATIONINFO_RECORD" destination="USESITUATIONINFO_RECORD" isDefinitionAutoGenerated="true" customColumnMap="false" isBodyDefinitionAutoGenerated="true"/>
    <TransformItem id="0" type="type" sourceSchema="FIRE" destSchema="FIRE" source="USESITUATIONINFO_TABLE" destination="USESITUATIONINFO_TABLE" isDefinitionAutoGenerated="true" customColumnMap="false" isBodyDefinitionAutoGenerated="true"/>
  </TransformItems>
  <Agents>
    <Strategy name="remoteExecute" value="false"/>
  </Agents>
  <Summay/>
</TransformTask>


-- 执行命令
./dts_cmd_run.sh config FILE=/usr/local/src/1.xml DESCRYPT_PASSWORD=0


-- oracle查看字符集
select userenv('language') from dual;

-- 达梦查看字符集 字符集在安装初始化库的时候指定,设定后不可更改
select SF_GET_UNICODE_FLAG();
select UNICODE ();
0 表示 GB18030,1 表示 UTF-8,2 表示 EUC-KR