SQL server: create local copy of remote table I have read access to a remote SQL Server that contains table 'dbo.myTable'. The problem I am facing is that it is slow to read the data remotely, especially for small frequent calls.

I also have a local SQL server. What is the most simple way to have a local copy of 'dbo.myTable', that is synchronised automatically with the main one? (I don't need second precision, maybe a few minutes lag is enough)

The data will only be modified on the remote one, as locally I will only read.

Thank you
You may want to consider transactional replication, which would allow you to have an initial snapshot of the table copied from the source system to the target system. After this initial snapshot, you can then configure transactional replication to push the data changes to the target system.

The requirement for transactional replication is that the table has a primary key, however, it is a feature that I have used for the purpose you described on many occasions. 

Bear in mind that replication would need to be activated on the source system and requires some administration to ensure it runs correctly. However, for a single table syncronization setup as described, it should cover everything you need.