How to synchronize two tables?

L

l4m3r2019-04-10 12:27:57

SQL

l4m3r, 2019-04-10 12:27:57

There are two remote servers. On each of them SqlServer + web application. Between them, only port 80/443 is open on both. And now there is one table, which, preferably, should always be the same (or at least synchronized once every N minutes) on both servers.
What kind of crutch can you come up with and is it possible to implement this at all?
As I understand it, you can run a CRON script on both servers and send it via RestAPI to another server. Is there an example?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

E

EVGENY T., 2019-04-10
@l4m3r

Most DBMSs are able to do replication - set it up and that's it.

P

ponaehal, 2019-04-10
@ponaehal

Please tell me:
1. You need to keep two tables the same, but what about the rest of the tables? Can they be the same or should they be different?
2. And what in MS SQLServer it is possible to configure replication for one separately taken table?
3. Whether you considered a variant on the necessary table to hang up the trigger and on dblink to change the target table in other system?