How to get data from another server with a request?

Question

SQL Server

Hello.
Just started working with SQL Server and faced the task of getting data from another server.
There is a server on which a certain calculation logic will be laid. And it is necessary to receive data from tables that are updated daily on another server.
Can you please tell me how to get data from another server?

Answer 1

That's what Linked Server technology is for. You create such object and then to it through OPENQUERY address. You can wrap it in a view for kosher, and it will be transparent to your recipient, as if you are working with a table from the same database. The only thing worth paying attention to is performance, in some cases with such a bunch it can sag.

Answer 2

Google on the topic "MS SQL Data Replication". This is for example