GC_DevUser库中gc_department表
dp_id int
dp_parentid int
dp_name varchar(100)
dp_sort_seq int
DevTrackerMy库中Organization表
Id int
Name nvarchar(50)
State bit
ParentId int
OrgTypeId int
dp_name与Name对应 dp_parentid与ParentId对应其他不用考虑
...全文
148122打赏收藏
同一个服务器上两个数据库之间做数据转移 求语句
GC_DevUser库中gc_department表 dp_id int dp_parentid int dp_name varchar(100) dp_sort_seq int DevTrackerMy库中Organization表 Id int Name nvarchar(50) State bit ParentId int OrgTypeId int dp_name与Name对应 dp_parentid与ParentId对应其他不用考虑
我是这么写的
Set Identity_Insert DevTrackerMy.dbo.Organization On
insert into DevTrackerMy.dbo.Organization(Id,Name,Describe,State,ParentId,Email,OrgTypeId )
select dp_id,dp_name,'1','False',dp_parentid,'1','1' from
GC_DevUser.dbo.gc_department
Set Identity_Insert DevTrackerMy.dbo.Organization OFF
把主见和自增去掉后报
Msg 8106, Level 16, State 1, Line 1
Table 'DevTrackerMy.dbo.Organization' does not have the identity property. Cannot perform SET operation.
首先用户有权限:
insert into DevTrackerMy.dbo.Organization(Id,Name,State,ParentId,OrgTypeId )
select null,dp_name,null,dp_parentid,null from
GC_DevUser.dbo.gc_department