How to achieve data synchronization?

kaffir1985

Now A is server, A has database db, B is client, and B also has the same database db as A.
If the data on A changes, then the database db on B also changes as the db on A changes. How do you achieve this? Is there any source code for this?

qwer000

It seems that it is said that the database can be copied and distributed. I haven't done it. Learn it

solowebwolf

1. To mark the synchronized and unsynchronized data. Available methods are time, dedicated update flags, self-incrementing ID, etc.
2.Synchronize the marked data.
3. Modify the mark.

A little bit like asking how to put the elephant in the refrigerator. :)

kaffir1985

I do n’t quite understand, there are no examples, let me see

zhengminglin

Publish and subscribe with data.

kaffir1985

Is there a good way? It must be implemented with a program

kaffir1985

I think sql Server has its own publishing and subscription functions. If you want to use the program to achieve how to design?
Thank you heroes

jjyytmlb

Use triggers.

chengshi508

Use triggers.

dongwin

How does this synchronize with the cache...
Just write a framework to update one database and update another database at the same time.