I'm trying to build up a database system using both peer-to-peer and normal transactional replication. However, it seems to be not able to combine both types of replications on one database.
This is the replication model which I'm trying to build.
I have already had two DB servers and one common database which could be synchronized between these two DB servers using peer-to-peer replication (2-way synchronizing). And then I attempt to use normal transactional to perform 1-way synchronizing but not
Always get this error:
Invalid column name '$sys_p2p_cd_id'.
Anyone has ideas to resolve the problem or suggestions to build this replication model. Please help.
View Complete Post