远程数据库迁移数据

  --创建链接服务器 
exec sp_addlinkedserver   ‘ITSV ‘, ‘ ‘, ‘SQLOLEDB ‘, ‘192.168.1.72‘ 
exec sp_addlinkedsrvlogin ‘ITSV ‘, ‘false ‘,null, ‘sa ‘, ‘!QAZ2wsx‘ 

--查询示例 
 insert into [AutoData].[dbo].[AutoData_Report_Account_Item] 
 select [AccountID]
      ,[AccountCode]
      ,[AccountName]
      ,[AccountTypeName]
      ,[AccountTypeCode]
      ,[AccountTypeNameSub1]
      ,[AccountTypeCodeSub1]
      ,[AccountTypeNameSub2]
      ,[AccountTypeCodeSub2]
      ,[Dr_Cr_EN]
      ,[Dr_Cr_CN]
      ,[Unit]
      ,[IsDelete]
      ,[CreateTime]
      ,[UpdateTime] from ITSV.[P3QA].[dbo].[P3_Report_Account_Item]

--以后不再使用时删除链接服务器 
exec sp_dropserver  ‘ITSV ‘, ‘droplogins ‘