不同数据库的表迁移SqlServer

INSERT INTO table  SELECT *  FROM  OPENDATASOURCE ('SQLOLEDB', 'Data Source=172.168.44.146;User ID=sa;password=123' ).table


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

posted @ 2019-02-21 10:59 756001160 阅读(...) 评论(...) 编辑 收藏