Somewhere recently I read of a method to connect one SQL Server to another, so clients could connect and run queries that appeared to come only from the first server. I cannot remember the proper terminology for this technique, and Google searches have not helped. I thought it was called “external connection”, or “external source”, but I cannot find this again.
Have I remembered correctly, and can someone give me an overview how to do this..?
To explain further, my preferred SQL client DBeaver only allows one connection in each query. As such, if I wish to join tables from two different servers, there’s no direct way to do it…except perhaps this method which I can’t remember how to do.
Advertisement
Answer
Take a look at the linked server in MsSQL.