'Manipulate the data from two not linked servers
At the moment I have two Microsoft SQL Servers with schema_1 and schema_2 respectively. Previously, these two schemes were on one server, and I wrote queries in which I could access these two schemes at once. Now, for some reason, these two schemes have been carried over to different servers and there is no way to make a linked server (and replication of the schema too). I have a question, how can I take data from two unconnected servers in order to write queries.
I have an assumption that I can use Python in order to read a table from one server, and then from another, but the question arises, how to implement complex logic in a query that used to be in SQL, and will now be rewritten in python, such approach may be ineffective.
My queries are more focused on the quality check with complex logic, could you advise a tool in which this can be implemented (except PowerBI) or data forums where I can ask this question.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|