17
Views
3
Comments
Solved
[Bulk Delete] Are FKs to deleted records set to NULL?
bulk-delete
Reactive icon
Forge asset by Sanjay Bankar
Application Type
Reactive

  Hi Sanjay,

  Are FKs in other entities, that are pointing to the deleted records, set to Null when you bulk delete data using your tool?

Thanks!

2025-04-30 07-30-15
Sanjay Bankar
Solution

Hi,

I have not considered such case ,,,i have considered bulk deletion operation with respect to a single entity that you may have seen in this demo. 

You may specify delete rule as per your requirements.


Regards,

Sanjay .

2017-11-17 23-02-39
Infosistema Solutions

OK, thank you for the fast reply! :)

Do you execute Delete or Truncate instructions?

FYI Only, in the DMM (Data Migration Manager) component here on the Forge, the Delete operation  sets the FKs that exist to the deleted record to NULL to avoid loss of references/data inconsistency. Although the component requires a paid subscription for other features, the Delete is a FREE feature :)

Screenshot_1.png
2025-04-30 07-30-15
Sanjay Bankar

Hello @Infosistema Solutions i am executing Delete instruction. and thank you so much for your information.


Regards

Sanjay

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.