M
M
mastersoftna2012-03-19 13:28:40
Database
mastersoftna, 2012-03-19 13:28:40

Synchronization between tables from databases on different servers?

There are tables of the company different in their structure, there are tables on different MS SQL servers. It is necessary to make changes in one table appear in another table on another server. What is the best way to make a way to detect the appearance of new data?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
4
4dmonster, 2012-03-19
@4dmonster

“What is the best way to make a way to detect the appearance of new data? „
Triggers
“It is necessary to make changes in one table appear in another table on another server.”
Linked server

4
4dmonster, 2012-03-19
@4dmonster

Oh sure.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question