Consult everybody, in order to realize multiple libraries of multiple tables for data completely in sync, what good method? I watched the publish-subscribe work function, seemingly only synchronous data of two libraries

CodePudding user response:

I personally is the use of the service broker completed

Regardless of which database, which table updates, you can send a message to the queue

Then queue to read relevant information, to complete the follow-up operation, better than the trigger, subscription didn't play, don't know how to compare

CodePudding user response:

Create a new central, create a new table:
DbId, the original owners key Id, other columns

All library data synchronization to the central,
As for how to sync, you can use a trigger to complete,
Or write custom log tables, with timing task to complete

CodePudding user response:

Why I must be at least four fields, dbid, tbid, pkid, procid