Data migration decision table

This table shows how additional modifications are made using the migration tool when there is a reference between skipped records in regular and delete migrations:

Delete migration


Referencing record - Horizontal; Referenced Record - Vertical	Delete (Project)	Skip Delete (Project)
Delete (Location)	No deselection - works as before	Skip deletion of referenced record
Skip Delete (Location)	No additional modifications	No additional modifications - both records are skipped

Regular migration


Referencing record - Horizontal; Referenced Record - Vertical	Insert (Project)	Update (Project)	Skip Insert (Project)	Skip Update (Project)
Insert (Location)	No deselection - works as before	No deselection - works as before	No additional modifications	No additional modifications
Update (Location)	No deselection - works as before	No deselection - works as before	No additional modifications	No additional modifications
Skip Insert (Location)	Nullify referencing Foreign Key: When the Foreign Key is nullable, the migration is successful When the Foreign Key is not nullable, the migration can fail with not null constraint violation exception	Keep referencing Foreign Key unchanged	No additional modifications - both records are skipped	No additional modifications - both records are skipped
Skip Update (Location)	No additional modifications	No additional modifications	No additional modifications - both records are skipped	No additional modifications - both records are skipped