Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
2 foreign keys from 2 different groups in 3 rd group
chnkumar
Hi experts,
I have a problem that
in deployment script, there r 3 groups, 3rd group has 1PK and 2FK. 2FKs are from 2 different groups
Pls check my DD file and correct me.
when i am deploying through OD UI its saying setting Up.....
In log also i am not able to find any error
Pls help me
Find more posts tagged with
Comments
Rick Poulin
DataDeploy requires that your groups be nested like a tree, so what you're trying to do with the third group is an invalid configuration. However, DD config files are not required to match your exact schema unless DD is also managing the creation of the tables. Just have group 3 use a FK to group 1, ignore the FK to group 2, and then let the database manage relational integrity (with triggers or deletion policies or that type of thing).