Does the backup preserves Master Detail and Lookup relationships such that they are reflected in the table and relationship (e.g. represented as foreign keys) structure of the target RDBMS?

Posted on March 7, 2017  / 

We do not create foreign key constraints because it would prevent copying records if they were done out of order, as you would get constraint violations if the child was copied before the parent. Also, some of the relationships (such as the ParentID of Attachment) point to multiple objects.