Post DB refresh - delete records

(1) Share

Report

Posted on by LB developer

382

Hi all,

After DB refresh from PROD to UAT, we can use DMF to update the record. However if we would like to delete some records, what will be the best way to do that? I don't think it is possible through DMF.

Thanks,

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, You can write SQL scripts or if restoring database using azure pipelines then you can add tasks in it

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi,

You can use open in excel feature also for deleting the records.

https://dynamics-tips.com/how-to-use-excel-add-in-dynamics-365-finance-and-operations/

Thanks,

Girish S.

Was this reply helpful? Yes No
LB developer 382 on at

Like (0)

Report

Adding a task in Azure DevOps pipeline - embed the SQL script in the task?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Excel Add-in can't be used to delete posted transactions. I would submit a MSFT ticket and ask them how best to delete the records.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi LB Developer,

What exact records do you need to delete and why?

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
You can delete multiple records from a database table by using a delete_from statement. For more details, you can view the link below:
delete_from | Microsoft Learn
Best Regards,
Hana

Was this reply helpful? Yes No