远程复制数据

SELECT TOP 1000 
    [BTID],[BTNAME],[DELTAG],[BCID]
INTO [TBusinessType]
FROM OPENDATASOURCE('SQLOLEDB','Data Source=192.168.0.94;User ID=DBTest;password=sa123**').[ClientCenter].[dbo].[TBusinessType]

 

 

--启用 Ad Hoc Distributed Queries
--所以必须得先启用 Ad Hoc Distributed Queries，使用结束后，最好关闭它
EXEC sp_configure 'show advanced options' ,1
RECONFIGURE
EXEC sp_configure 'Ad Hoc Distributed Queries' ,1
RECONFIGURE

GO


--访问远程数据库表
SELECT TOP 1000 
    [BTID],[BTNAME],[DELTAG],[BCID]
INTO [TBusinessType]
FROM OPENDATASOURCE('SQLOLEDB','Data Source=192.168.0.94;User ID=DBTest;password=sa123**').[ClientCenter].[dbo].[TBusinessType]
 


--使用完成后，关闭 Ad Hoc Distributed Queries
EXEC sp_configure 'Ad Hoc Distributed Queries' ,0
RECONFIGURE

EXEC sp_configure 'show advanced options' ,0
RECONFIGURE