将数据从一台服务器插入另一台服务器? [英] Insert Data From One Server To Another?

问题描述

如果我想在SQL Server中运行这种查询，如何从连接到另一台服务器的一台服务器上执行相同的查询?

If I want to run this sort of query in SQL Server, how can I do the same query from one server I am connected to to another?

我尝试添加"[ServerName1]".在"[DatabaseName1].[dbo] ..."和"[ServerName2]"之前.在"[DatabaseName2].[dbo] ..."之前，但这似乎不起作用.

I tried adding "[ServerName1]." before "[DatabaseName1].[dbo]..." and "[ServerName2]." before "[DatabaseName2].[dbo]..." but that didn't seem to work.

INSERT INTO [DatabaseName1].[dbo].[TableName]
           ([FieldName])
     SELECT [FieldName] FROM [DatabaseName2].[dbo].[TableName]

这可能吗?

推荐答案

是的，您可以在所有对象名称的其余部分之前使用服务器名称，例如:

Yes you would use the server-name before the whole rest of object-name like:

myserver.mydatabase.dbo.mytable

但是，您首先必须设置链接服务器.在BOL中查找链接的服务器.

However you first have to set up linked servers. Look up linked servers in BOL.

这篇关于将数据从一台服务器插入另一台服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！