Unanswered: Replication: problem of connecting interruption
I'm setting up peer-to-peer replication topology. Now, my two sites are working well, both sites could make changes to the common database and the common database is synchronized between the two sites.
However I have a question which I still not have the answer my self.
In the case, I have 10 tables need to be synchronized and when one site has finished updating 5 tables and still has 5 tables remains to be replicated but the connection between the two sites is broken.
In this case our application doesn't not work properly because of missing data from 5 remaining tables (which was not replicated).
I still not have a complete solution for this case.
Do you have any idea for this case ? Please help me !