Activity overview
Latest activity by VmWare
Row internal rule on a primary key
If I have a primary key (for example email), would I be able to mask that primary key with a row internal rule? The "emails" data sets do not conform to our format of (firstname.lastname) so I want...
I'm getting an error when I try to do it via column name. I attached screenshots below of my test tables and the error I'm getting. For reference "EmployeeNo" is the primary key in the first table which is referenced by the EmployeeNo column as a foreign key in the second table. [image] [image] [image] / comments
I'm getting an error when I try to do it via column name. I attached screenshots below of my test tables and the error I'm getting. For reference "EmployeeNo" is the primary key in the first table ...
Hi DanC, Sorry I am bit confused about the process. When I normally sync two tables with a relationship, I just specify the other table's foreign key in the sync manager, however when it is cross schema, sync manager does not detect the other foreign key. I'm also not too sure what you meant when you said you could "Change the ID" to go across schemas and when you said to "enable the two cross schema rule options on the Rule Options drop down of the Misc". I do see the option to enable "cross database" but there is no rule for cross schema. Just wondering if there is some documentation to show this process as I have successfully done syncing across tables of the same schema just not tables from another schema. Thanks, Derek / comments
Hi DanC,Sorry I am bit confused about the process. When I normally sync two tables with a relationship, I just specify the other table's foreign key in the sync manager, however when it is cross sc...
Mask a primary and foreign key relationship across a different schema
Is there a way to mask a primary/foreign key relationship that are using different schemas? The two tables are on two different controllers so when I open "Synchronization Manager", it doesn't show...