为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:麒麟
【CPU】:
【问题描述】*:sql server迁移数据到DM8 报错无效的列名[ROWID]
下面是sql server 语法:
CREATE TABLE [dbo].[cq_wyzj_buildinginfo] (
[BELONGXIAQUCODE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[OPERATEUSERNAME] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[OPERATEDATE] datetime NULL,
[ROW_ID] int NULL,
[YEARFLAG] nvarchar(4) COLLATE Chinese_PRC_CI_AS NULL,
[ROWGUID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[COMMUNITYNAME] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[COMMUNITYGUID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[COMMUNITYNUM] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[OWNERSCOMMITTEE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[PRPTYMACOMPANY] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[DVLPTCOMPANY] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[DOORNUMBER] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[BUILDINGNUM] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[BUILDINGNAME] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSEGRADE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSEGRADEVALUE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSETYPE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSETYPEVALUEAAUE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[COMPLETIONDATE] datetime NULL,
[HOUSELEVEL] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSELEVELVALUE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSINGSTRUCTURE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[HOUSINGSTRUCTUREVALUE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[STAIRSUNITSNUM] int NULL,
[UPFLOORSNUM] int NULL,
[DOWNFLOORSNUM] int NULL,
[PUBLICAREA] numeric(18,2) NULL,
[RESIDENTIALAREA] numeric(18,2) NULL,
[HOUSENUM] int NULL,
[COMMONAREA] numeric(18,2) NULL,
[REMARK] nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL,
[ADDUSERNAME] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ADDUSERGUID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ADDOUNAME] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ADDOUGUID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ADDOUCODE] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[LASTMODIFYDATETIME] datetime NULL,
[LASTMODIFYUSERNAME] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[LASTMODIFYUSERGUID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ISHAVELIFT] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[DVLPTCOMPANYNUM] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[PRPTYMACOMPANYNUM] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[L_DONG_ID] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
[ROWID] uniqueidentifier DEFAULT (newid()) NOT NULL,
[housexx] varchar(10) COLLATE Chinese_PRC_CI_AS NULL,
[buildarea] numeric(9) NULL,
[tnarea] numeric(9) NULL,
[housecj] varchar(10) COLLATE Chinese_PRC_CI_AS NULL
)
ROWID是关键字,dts迁移时,连接目的端达梦可配置自定义连接,添加关键字参数,设置RWOID关键字再迁移