I have 2 publications for 1 database and between those 2 publications there are tables with referential relationships.
For example: publication 1 has "Employees" and publication 2 has "EmployeeJobs" Our software Always syncrhonizes publication 1 first and then publication 2. Unfortunately, sometimes EmployeeJobs and Employees are deleted at the same time in the Consolidated database. This results in Referential integrity problems when synchronizing. Because publication 1 attempts to delete the Employee while there are still EmployeeJobs available. (I could reverse the order of sync between the publications but then I will get problems when Adding new Employees with EmployeeJobs).
When the 2 tables are inside 1 publication I know that Mobilink solves this issue for you (see thread: http://sqlanywhere-forum.sap.com/questions/25236/why-are-child-records-deleted-while-there-is-no-cascade-in-remote-db-mobilink )
I would like to apply this logic over multiple publications as well. Is this possible?
asked 04 Nov '15, 04:11