本文介绍了跨服务器SQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想将数据从一台服务器的数据库移植到另一台服务器的数据库. 这些数据库都位于不同的mssql 2005服务器上. 复制可能不是一种选择,因为目标数据库是在[时间间隔]基础上从头生成的.
I want to port data from one server's database to another server's database. The databases are both on a different mssql 2005 server. Replication is probably not an option since the destination database is generated from scratch on a [time interval] basis.
最好我会做类似的事情
insert * from db1/table1 into db2/table2 where rule1 = true很明显,连接凭据将在此脚本中存储.
It's obvious that connection credentials would go in somehwere in this script.
推荐答案我认为您要按照这篇 msdn文章.然后,您将使用4部分对象名称进行选择,例如:
I think what you want to do is create a linked server as per this msdn article. You would then select using a 4 part object name eg:
Select * From ServerName.DbName.SchemaName.TableName更多推荐
跨服务器SQL
发布评论