Post DB refresh - delete records

(1) Share

Report

Posted on by LB developer

396

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,

All responses (6)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
LB developer 396 on at

Like (0)

Report
Copy link

Link copied!

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

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
André Arnaud de Cal... 307,445 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi LB Developer,

What exact records do you need to delete and why?
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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