达梦DMV8迁移工具DTS部署和使用案例

安装DTS工具

DTS是达梦DMV8的客户端工具，随着DM软件一起发布

迁移场景

一、源端
1、10.0.0.21 oracle 11gR2
2、数据库名字为crm，gbk字符集
2、usercrm用户下的表为待迁移

二、目标端
1、10.0.0.22 dmv8
2、数据库名字为ERP，gb18030字符集
3、crm用户为目标端用户

迁移过程

启动dts

[dmdba@oradb1 dm8]$cd /dm8/dmdbms/tool
[dmdba@oradb1 tool]$ ./dts
Xlib:  extension "RANDR" missing on display "10.0.0.1:0.0".
2022-05-30 23:05:54 [com.dameng.dts.rcp.dialog.TransformDialog]
[INFO] /dm8/dmdbms/tool/workspace/local/dts/oracle-11g->dm8/1653923154543.xml

<?xml version="1.0" encoding="UTF-8"?>

<!--The file was generated by DM DTS tools, do not edit manually. Generation time 2022-05-30 23:21:36.-->
<TransformTask transformer="11" generate_transformer_log="false"> 
  <Source type="db" useCustomDriver="false" useDefaultURL="true"> 
    <Server>10.0.0.21</Server>
    <Port>1521</Port>
    <AuthType>0</AuthType>
    <Compress>false</Compress>
    <User>SYSTEM</User>
    <Password>3B2FCC63697C85FAB415BC2BF36ADEF2</Password>
    <Service>crm</Service>
  </Source>  
  <Destination type="db" useCustomDriver="false" useDefaultURL="true"> 
    <Server>10.0.0.21</Server>
    <Port>5236</Port>
    <AuthType>0</AuthType>
    <Compress>false</Compress>
    <DmType>dm</DmType>
    <User>SYSDBA</User>
    <Password>F1A54AF6DA530F3F</Password>
  </Destination>  
  <Mode useDefaultDataTypeMap="true" lengthInChar="1" simple="false" objectNameToUpperCase="false" transformerDefault="false" isQuery="false"> 
    <DBStrategies>
      <Strategy>TRANSFORM_CONTEXTES</Strategy>
      <Strategy>TRANSFORM_SCHEMAS</Strategy>
      <Strategy>TRANSFORM_SYNONYM_PUBLICS</Strategy>
      <Strategy>TRANSFORM_DIRECTORIES</Strategy>
    </DBStrategies>
    <Schema source="USERCRM" destination="CRM">
      <Strategies>
        <Strategy>TRANSFORM_TABLES</Strategy>
        <Strategy>TRANSFORM_SYNONYM</Strategy>
        <Strategy>TRANSFORM_SEQUENCES</Strategy>
        <Strategy>TRANSFORM_VIEWS</Strategy>
        <Strategy>TRANSFORM_DATABASE_AND_SCHEMA_TRIGGERS</Strategy>
        <Strategy>TRANSFORM_TYPES</Strategy>
        <Strategy>TRANSFORM_PROCEDURE_FUNCTIONS</Strategy>
        <Strategy>TRANSFORM_MVIEWS</Strategy>
        <Strategy>TRANSFORM_PACKAGES</Strategy>
      </Strategies>
    </Schema>
  </Mode>  
  <TransformItems continueWhenError="true" multiThread="true"> 
    <TransformItem fetchSize="500" batchSize="500" bufferSize="2" fetchSize_lob="500" batchSize_lob="500" bufferSize_lob="2" id="0" type="table" sourceSchema="USERCRM" destSchema="CRM" source="T01" destination="T01" isDefinitionAutoGenerated="true" includeTableStorage="false" includeIndexStorage="false">
      <Strategies>
        <Strategy>TRANSFORM_INDEXES</Strategy>
        <Strategy>CREATE</Strategy>
        <Strategy>TRANSFORM_PRIMARY_KEY</Strategy>
        <Strategy>TRANSFORM_TABLE_TRIGGERS</Strategy>
        <Strategy>TRANSFORM_COMMENTS</Strategy>
        <Strategy>INSERT_ROW</Strategy>
        <Strategy>IDENTITY_INSERT</Strategy>
        <Strategy>TRANSFORM_CHECK_CONSTRAINTS</Strategy>
        <Strategy>TRANSFORM_UNIQUE_CONSTRAINTS</Strategy>
        <Strategy>TRANSFORM_FOREIGN_KEY</Strategy>
      </Strategies>
    </TransformItem>
    <TransformItem fetchSize="500" batchSize="500" bufferSize="2" fetchSize_lob="500" batchSize_lob="500" bufferSize_lob="2" id="0" type="table" sourceSchema="USERCRM" destSchema="CRM" source="T02" destination="T02" isDefinitionAutoGenerated="true" includeTableStorage="false" includeIndexStorage="false">
      <Strategies>
        <Strategy>TRANSFORM_INDEXES</Strategy>
        <Strategy>CREATE</Strategy>
        <Strategy>TRANSFORM_PRIMARY_KEY</Strategy>
        <Strategy>TRANSFORM_TABLE_TRIGGERS</Strategy>
        <Strategy>TRANSFORM_COMMENTS</Strategy>
        <Strategy>INSERT_ROW</Strategy>
        <Strategy>IDENTITY_INSERT</Strategy>
        <Strategy>TRANSFORM_CHECK_CONSTRAINTS</Strategy>
        <Strategy>TRANSFORM_UNIQUE_CONSTRAINTS</Strategy>
        <Strategy>TRANSFORM_FOREIGN_KEY</Strategy>
      </Strategies>
    </TransformItem>
    <TransformItem fetchSize="2048" batchSize="2048" bufferSize="2" fetchSize_lob="2048" batchSize_lob="2048" bufferSize_lob="2" id="0" type="table" sourceSchema="USERCRM" destSchema="CRM" source="T03" destination="T03" isDefinitionAutoGenerated="true" includeTableStorage="false" includeIndexStorage="false">
      <Columns>
        <Column sourceName="ID" destName="ID" typeName="NUMBER" typeCode="3" precision="38" scale="0" isVirtual="false" nullable="true" isIdentity="false" isDatabaseExpr="false"/>
        <Column sourceName="NAME" destName="NAME" typeName="VARCHAR2" typeCode="12" precision="50" scale="0" isVirtual="false" nullable="true" isIdentity="false" isDatabaseExpr="false"/>
      </Columns>
      <Strategies>
        <Strategy>TRANSFORM_INDEXES</Strategy>
        <Strategy>CREATE</Strategy>
        <Strategy>TRANSFORM_PRIMARY_KEY</Strategy>
        <Strategy>TRANSFORM_COMMENTS</Strategy>
        <Strategy>INSERT_ROW</Strategy>
        <Strategy>IDENTITY_INSERT</Strategy>
        <Strategy>TRANSFORM_CHECK_CONSTRAINTS</Strategy>
        <Strategy>TRANSFORM_UNIQUE_CONSTRAINTS</Strategy>
        <Strategy>TRANSFORM_FOREIGN_KEY</Strategy>
      </Strategies>
    </TransformItem>
  </TransformItems>  
  <Summay/> 
</TransformTask>

SQL> select count(*) from crm.t01;

LINEID     COUNT(*)            
---------- --------------------
1          4000

used time: 0.458(ms). Execute id is 1303.
SQL> select count(*) from crm.t02;

LINEID     COUNT(*)            
---------- --------------------
1          10000

used time: 0.431(ms). Execute id is 1304.
SQL> select count(*) from crm.t03;

LINEID     COUNT(*)            
---------- --------------------
1          2000

used time: 0.383(ms). Execute id is 1305.
SQL> 
SQL> 
SQL> desc crm.t01

LINEID     NAME TYPE$       NULLABLE
---------- ---- ----------- --------
1          ID   DEC(38)     Y
2          NAME VARCHAR(50) Y

used time: 5.834(ms). Execute id is 1306.
SQL> 
SQL> desc crm.t02

LINEID     NAME TYPE$       NULLABLE
---------- ---- ----------- --------
1          ID   DEC(38)     Y
2          NAME VARCHAR(50) Y

used time: 9.459(ms). Execute id is 1307.
SQL> 
SQL> 
SQL> desc crm.t03

LINEID     NAME TYPE$       NULLABLE
---------- ---- ----------- --------
1          ID   DEC(38)     Y
2          NAME VARCHAR(50) Y

used time: 6.203(ms). Execute id is 1308.
SQL> 
SQL> 
SQL> 

达梦在线服务平台：https://eco.dameng.com