Foreign Key handling during data migration to MS365

(0) Share

Report

Posted on by Atin

Hi,

We are migrating huge data from SQL/oracle database to MS dynamics. Want to understand how should we take care of Foreign key relationship between entities. Example We loaded account details and now we have to load contacts but contact is having FK column(GUID) from Account which is only generated when we load data in account. So want to understand how should we handle this in data migration stage.

I have the same question (0)

All responses (2)

Answers (0)

meelamri 13,216 User Group Leader on at

Like (0)

Report

Hi Atin,

you can use alternate key:

www.beringer.net/.../

Was this reply helpful? Yes No
Atin 10 on at

Like (0)

Report

Thanks for quick response. Our requirement is how to handle this FK relation in child table which is populating from master table.

Was this reply helpful? Yes No