Database scrub

(0) Share

Report

Posted on by Summit_Steve

Hello All,

In AX2012 there was an unsupported class that you could execute to delete all data in the database. I was wondering if a similar class or job existed in D365, or if anyone has a routine or script they followed to do the same.

My goal here is to get a scrubbed copy of our PROD database into a DEV VM for the purpose of development. We want to take precautions for eliminating risk associated to our customer list, vendors, credit cards, etc when restoring our PROD DB to DEV VMs for development and testing purposes.

Any help is appreciated.

Thanks,

Steve

I have the same question (0)

All responses (2)

Answers (1)

Summit_Steve on at

Like (0)

Report

RE: Database scrub

Hi Andre,

Yes. That is the class I remember using. Thanks for the tip.

Steve

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 297,399 Super User 2025 Season 2 on at

Like (0)

Report

RE: D365 F&O Database scrub

Hi Steve,

The class SysDatabaseTransDelete is still available in the application and will work. Note that it is not supported and might leave some tables untouched causing inconsistent data. Ensure you will never run it on a production environment.

You can run the class by changing the URL parameters to: &cmp=USMF&mi=SysClassRunner&cls=SysDatabaseTransDelete.

Replace USMF with the actual company ID for which you want to delete the transactions.

Was this reply helpful? Yes No