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.

Categories:

Data Loader

All responses (2)

Answers (0)

Atin 10 on at

Like (0)

Report

RE: Foreign Key handling during data migration to MS365

Thanks for quick response. Our requirement is how to handle this FK relation in child table which is populating from master table.
meelamri 13,198 User Group Leader on at

Like (0)

Report

RE: Foreign Key handling during data migration to MS365

Hi Atin,

you can use alternate key:

www.beringer.net/.../