I have a different source and destination database server with the same name.
On a periodic interval, we push "new" data configuration to the source database and manually update the data in the destination database.
Instead of handling it manually, we are trying to do one time "new" data distribution from source db to the listed linked server destination db's.
I presume that if we use "Linked Server"s it can help to achieve the data distribution by validating missing (or) unavailable records in the destination database servers.
Scenario : New price data distribution from source database to the client databases. We might have new price for new products (or) new price for existing products. Based on the "new" data changes or "new" data in the source db, we will have to distribute the client db.
How do I distribute data from the source database to the destination database in