J
jokilval
Guest
Hi, I referred the config guide when configuring the Pro2 installations. The problem is that even with the own installations for each tenant, the Pro2 administration tool is always showing the mapping etc. to all the tenants even if they have their own installations. As I stated, Pro2 is trying to connect to both tenants A and B even if I start the admin tool from tenant A install location of Pro2. The replbatch.bat won't run because it cannot connect to the other tenant B because that tenant is not to be connected in the installation location of tenant A. I guess this is CDC problem with multi-tenancy as the CDC policies are for the database which is the same for both tenants and Pro2 is using these policies and it messes up the Pro2. However, If I have only one installation of Pro2 for one tenant, the replication is working fine. So if there could be a way around the problem so that I could somehow "force" the Pro2 tool to not to try to connect to the other tenants when replicating. I can see from the CDC monitor that it is correctly getting the changes but the problem is with the replication as it won't run because of the problem I explained above. As you stated that Pro2 does support multi tenant database replication without having CDC feature. So I guess Pro2 doesn't support CDC for multi tenant database and one should use triggers instead...
Continue reading...
Continue reading...