sql 不同服务器，相同数据库导数据；一台服务器，不同数据库导数据

启用Ad Hoc Distributed Queries：

exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

 

insert into opendatasource('SQLOLEDB','Data Source=192.168.1.111;User ID=sa;Password=123456;database=****').****.dbo.****(Title,Ncontent,Quarry,[Image],createTime,updateTime,userId,spaceId,displayStyle,readNum,grade) select Title,NContent,Quarry,Images,updateTime,updateTime,updateId,spaceId,displayStyle,readNum,grade from opendatasource('SQLOLEDB','Data Source=***.***.**.***;User ID=sa;Password=*********;database=****').***.dbo.***

 

 

使用完成后，关闭Ad Hoc Distributed Queries：

exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure