Synchronization between tables from databases on different servers?

There are tables different in structure, are the tables on different servers of MS SQL. You need to make changes in one table appearing in another table on another server. How to make a better way of detecting new data?
October 8th 19 at 01:52
2 answers
October 8th 19 at 01:54
"How to make a better way of detecting new data? "
Triggers

"We need to make changes in one table appearing in another table on another server."
Linked server
Sorry, not previously encountered with Linked Server. Can I make the triggers on your local server, but that he was tied to a table on the second, remote server? - melyna.Lueilwitz commented on October 8th 19 at 01:57
Read about the Change Tracking mechanism, with it you will be able to identify all changes in the required tables. The synchronization process can be implemented in SSIS. - Shea commented on October 8th 19 at 02:00
Sorry, instead of answering, left a comment... - Shea commented on October 8th 19 at 02:03
October 8th 19 at 01:56
Yes, of course.

Find more questions by tags SQL ServerSynchronization of data.NETDatabases