为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8_20260709_x86_win_64、dm8_20260710_x86_CentOS7_64
【操作系统】:windows、linux
【CPU】:
【问题描述】*:Windows、Linux部署了两套同版本的数据库,在windows上DM管理器中作业配置数据迁移任务,执行没有明显报错,但是Linux库中没有数据同步过来。
但是使用DTS可以正常进行迁移。
一下是迁移配置文件,放在桌面的
<?xml version="1.0" encoding="UTF-8"?>
<!--本文件由DM数据迁移工具生成,请不要手工修改,生成时间2026-08-16 10:07:39.-->
<TransformTask transform="4" name="2.110">
<Source version="1.0" type="db" useCustomDriver="false" useDefaultURL="true">
<Server>127.0.0.1</Server>
<Port>5236</Port>
<AuthType>0</AuthType>
<Compress>false</Compress>
<DmType>dm</DmType>
<User>SYSDBA</User>
<Password>D9737D10310352C2B95D8C0FAD06F7F3</Password>
</Source>
<Destination version="1.0" type="db" useCustomDriver="false" useDefaultURL="true">
<Server>192.168.2.110</Server>
<Port>5236</Port>
<AuthType>0</AuthType>
<Compress>false</Compress>
<DmType>dm</DmType>
<User>SYSDBA</User>
<Password>D9737D10310352C2B95D8C0FAD06F7F3</Password>
</Destination>
<Config version="1.0" selectObjType="1">
<Strategy name="indexRename" value="true"/>
<Strategy name="createTableParallel" value="false"/>
<Strategy name="createIndexParallel" value="false"/>
<Strategy name="createPkParallel" value="false"/>
<Strategy name="allParallel" value="false"/>
<Strategy name="itemBatchSize" value="50"/>
<Strategy name="itemBufSize" value="4"/>
<Strategy name="fillThreadCount" value="2"/>
<Strategy name="taskBufSize" value="4"/>
<Strategy name="batchMaxSize" value="0"/>
<Strategy name="batchLobMaxSize" value="0"/>
<Strategy name="batchMaxTime" value="60"/>
<Strategy name="globalFldr" value="false"/>
<Strategy name="retryConnect" value="true"/>
<Strategy name="retryConnectCount" value="3"/>
<Strategy name="retryConnectInterval" value="15"/>
<Strategy name="lengthInChar" value="1.0"/>
<Strategy name="continueWhenError" value="true"/>
<Strategy name="threadCount" value="2"/>
<Strategy name="objectNameToUpperCase" value="true"/>
</Config>
<Mode version="1.0" simple="false">
<DBStrategies>
<Strategy>TRANSFORM_SCHEMAS</Strategy>
</DBStrategies>
<Schema source="SALES" destination="SALES">
<Strategies>
<Strategy name="schObjectStrategys" value="TRANSFORM_TABLES,TRANSFORM_VIEWS,TRANSFORM_MVIEWS,TRANSFORM_SEQUENCES,TRANSFORM_PROCEDURE_FUNCTIONS,TRANSFORM_DATABASE_AND_SCHEMA_TRIGGERS,TRANSFORM_PACKAGES,TRANSFORM_CLASSES,TRANSFORM_SYNONYM,TRANSFORM_TYPES,CREATE"/>
</Strategies>
</Schema>
</Mode>
<TransformItems version="1.0" ItemCount="8">
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="CUSTOMER" destination="CUSTOMER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="CUSTOMER_ADDRESS" destination="CUSTOMER_ADDRESS" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="MYINFO" destination="MYINFO" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="SALESORDER_DETAIL" destination="SALESORDER_DETAIL" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="SALESORDER_HEADER" destination="SALESORDER_HEADER" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="SALESPERSON" destination="SALESPERSON" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
<TransformItem id="0" type="table" sourceSchema="SALES" destSchema="SALES" source="TABLE_1" destination="TABLE_1" isDefinitionAutoGenerated="true" customColumnMap="false" partitionAsList="false"/>
</TransformItems>
<Agents version="1.0">
<Strategy name="remoteExecute" value="false"/>
</Agents>
<Summay version="1.0">
<textPage>false</textPage>
</Summay>
</TransformTask>
目的端SQL日志有SQL入库的记录吗?
可以在dts中配置迁移任务作业及调度并执行

可以把迁移失败的日志贴出来。
可能是和ip地址127.0.0.1 有关系。