达梦数据迁移工具DM DTS提供了主流大型数据库迁移到DM、DM到DM、文件迁移到DM以及DM迁移到文件的功能。

得益于达梦数据库对目前主流大型关系型数据库系统有着业界领先的兼容性，在存储层面、语法层面、接口层面和它们保持高度兼容，借助于DM图形界面且采用向导方式引导各个迁移步骤的DTS工具，移植工作可以变得非常的简单，下文简要介绍db2数据库迁移的简单步骤

打开dts的工具

dts 在 transform manager 新建transforms name:db2--dm

右侧出现传输向导点击next

选择源数据库

填入 ip地址及用户名及用户名称和密码

点击下一步选在源数据库中的schema ，这里选择db2inst1

点击next

从结果看大部分的数据传输完成有18个错误如下有些别名的对象没有给列出来，所以迁移的过程中还有做下专门的梳理一定要梳理清楚自己的系统中有哪些对象。以下是在迁移过程中出现的问题

1、迁移过程中不支持别名，导致如果外键创建不成功

/* Task Failed: Add foreign key constraint RPP on table "DB2INST1"."PROJECT" */

/* Related SQL statement */

ALTER TABLE "DB2INST1"."PROJECT" ADD FOREIGN KEY("MAJPROJ") REFERENCES "DB2INST1

"."PROJ"("PROJNO") ON DELETE CASCADE ;

2、blob 在传输过程中，转换成了 text ，而达梦不支持在text上创建索引导致创建索引不成功

create table dd (dd text)

create index xx on dd(dd) （失败）

3、xml在转换过程中也变成了 text ,在text 上不支持建索引

以下是完整的错误信息

/* Task Failed: Add foreign key constraint RPP on table "DB2INST1"."PROJECT" */

/* Related SQL statement */

ALTER TABLE "DB2INST1"."PROJECT" ADD FOREIGN KEY("MAJPROJ") REFERENCES "DB2INST1

"."PROJ"("PROJNO") ON DELETE CASCADE ;

/* Task Failed: Add foreign key constraint FK_PROJECT_2 on table "DB2INST1"."PR

OJECT" */

/* Task Failed: Add foreign key constraint FK_PROJECT_2 on table "DB2INST1"."PR

OJECT" */

/* Related SQL statement */

ALTER TABLE "DB2INST1"."PROJECT" ADD FOREIGN KEY("RESPEMP") REFERENCES "DB2INST1

"."EMP"("EMPNO");

/* Task Failed: Add foreign key constraint FK_PROJECT_1 on table "DB2INST1"."PR

OJECT" */

/* Task Failed: Add foreign key constraint FK_PROJECT_1 on table "DB2INST1"."PR

OJECT" */

/* Related SQL statement */

ALTER TABLE "DB2INST1"."PROJECT" ADD FOREIGN KEY("DEPTNO") REFERENCES "DB2INST1"

."DEPT"("DEPTNO");

/* Task Failed: Add foreign key constraint RPAP on table "DB2INST1"."PROJACT" *

/

/* Task Failed: Add foreign key constraint RPAP on table "DB2INST1"."PROJACT" *

/

/* Related SQL statement */

ALTER TABLE "DB2INST1"."PROJACT" ADD FOREIGN KEY("PROJNO") REFERENCES "DB2INST1"

."PROJ"("PROJNO");

/* Task Failed: Add foreign key constraint FK_EMP_RESUME on table "DB2INST1"."E

MP_RESUME" */

/* Task Failed: Add foreign key constraint FK_EMP_RESUME on table "DB2INST1"."E

MP_RESUME" */

/* Related SQL statement */

ALTER TABLE "DB2INST1"."EMP_RESUME" ADD FOREIGN KEY("EMPNO") REFERENCES "DB2INST

1"."EMP"("EMPNO");

/* Task Failed: Add foreign key constraint FK_EMP_PHOTO on table "DB2INST1"."EM

P_PHOTO" */

/* Task Failed: Add foreign key constraint FK_EMP_PHOTO on table "DB2INST1"."EM

P_PHOTO" */

/* Related SQL statement */

ALTER TABLE "DB2INST1"."EMP_PHOTO" ADD FOREIGN KEY("EMPNO") REFERENCES "DB2INST1

"."EMP"("EMPNO");

/* Task Failed: Add foreign key constraint RED on table "DB2INST1"."EMPLOYEE" *

/

/* Task Failed: Add foreign key constraint RED on table "DB2INST1"."EMPLOYEE" *

/

/* Related SQL statement */

ALTER TABLE "DB2INST1"."EMPLOYEE" ADD FOREIGN KEY("WORKDEPT") REFERENCES "DB2INS

T1"."DEPT"("DEPTNO") ON DELETE SET NULL ;

/* Task Failed: Add foreign key constraint RDE on table "DB2INST1"."DEPARTMENT"

*/

/* Task Failed: Add foreign key constraint RDE on table "DB2INST1"."DEPARTMENT"

*/

/* Related SQL statement */

ALTER TABLE "DB2INST1"."DEPARTMENT" ADD FOREIGN KEY("MGRNO") REFERENCES "DB2INST

1"."EMP"("EMPNO") ON DELETE SET NULL ;

/* Task Failed: Add foreign key constraint ROD on table "DB2INST1"."DEPARTMENT"

*/

/* Task Failed: Add foreign key constraint ROD on table "DB2INST1"."DEPARTMENT"

*/

/* Related SQL statement */

ALTER TABLE "DB2INST1"."DEPARTMENT" ADD FOREIGN KEY("ADMRDEPT") REFERENCES "DB2I

NST1"."DEPT"("DEPTNO") ON DELETE CASCADE ;

/* Task Failed: Create index PO_ZIP_XMLIDX on table "DB2INST1"."PURCHASEORDER"

*/

/* Task Failed: Create index PO_ZIP_XMLIDX on table "DB2INST1"."PURCHASEORDER"

*/

/* Related SQL statement */

CREATE INDEX "INDEX1312856382000280"

ON "DB2INST1"."PURCHASEORDER"("PORDER");

/* Task Failed: Create index PO_CID_XMLIDX on table "DB2INST1"."PURCHASEORDER"

*/

/* Task Failed: Create index PO_CID_XMLIDX on table "DB2INST1"."PURCHASEORDER"

*/

/* Related SQL statement */

CREATE INDEX "INDEX1312856382662120"

ON "DB2INST1"."PURCHASEORDER"("PORDER");

/* Task Failed: Create index PO_PRODS_XMLIDX on table "DB2INST1"."PURCHASEORDER

" */

/* Task Failed: Create index PO_PRODS_XMLIDX on table "DB2INST1"."PURCHASEORDER

" */

/* Related SQL statement */

CREATE INDEX "INDEX1312856383201930"

ON "DB2INST1"."PURCHASEORDER"("PORDER");

/* Task Failed: Create index PROD_DETAIL_XMLIDX on table "DB2INST1"."PRODUCT" *

/

/* Task Failed: Create index PROD_DETAIL_XMLIDX on table "DB2INST1"."PRODUCT" *

/

/* Related SQL statement */

CREATE INDEX "INDEX1312856390437240"

ON "DB2INST1"."PRODUCT"("DESCRIPTION");

/* Task Failed: Create index PROD_NAME_XMLIDX on table "DB2INST1"."PRODUCT" */

/* Related SQL statement */

CREATE INDEX "INDEX1312856390980760"

ON "DB2INST1"."PRODUCT"("DESCRIPTION");

/* Task Failed: Create index CUST_NAME_XMLIDX on table "DB2INST1"."CUSTOMER" */

/* Related SQL statement */

CREATE INDEX "INDEX1312856444514910"

ON "DB2INST1"."CUSTOMER"("INFO");

/* Task Failed: Create index CUST_PHONET_XMLIDX on table "DB2INST1"."CUSTOMER"

*/

/* Task Failed: Create index CUST_PHONET_XMLIDX on table "DB2INST1"."CUSTOMER"

*/

/* Related SQL statement */

CREATE INDEX "INDEX1312856445120150"

ON "DB2INST1"."CUSTOMER"("INFO");

/* Task Failed: Create index CUST_PHONES_XMLIDX on table "DB2INST1"."CUSTOMER"

*/

/* Task Failed: Create index CUST_PHONES_XMLIDX on table "DB2INST1"."CUSTOMER"

*/

/* Related SQL statement */

CREATE INDEX "INDEX1312856445685870"

ON "DB2INST1"."CUSTOMER"("INFO");

/* Task Failed: Create index CUST_CID_XMLIDX on table "DB2INST1"."CUSTOMER" */

/* Related SQL statement */

CREATE UNIQUE INDEX "INDEX1312856446242430" ON "DB2INST1"."CUSTOMER"("INFO");

ITPub博客

db2数据库迁移达梦数据库步骤和遇到的几个问题