'SQL how to compare two tables from different servers?

I have a table job_order with column order_no in my store_db. Is there a way or query that I can compare if data from the order_no column matched with the same column but on a different database server?

Note that server1 and server2 has the same database. I would appreciate the help. Thank you!

sqlsql-server


Solution 1:[1]

Different approaches can be used to achieve the table comparison:

  1. Create a Linked Server connection, then create a Stored Procedure that performs a comparison on the Target Server.

A wide option exists to achieve an effective table data comparison.

References:

Table Comparison

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Data Slugger

Related Questions