Finance | Project Operations, Human Resources, ...

Backup without transaction data in D365 F&O

(0) Share

Report

Posted on by Community member

I need to copy data from Tier 2 environment to Tier 1 environment without transactional data. Only need master and configuration data. Is there any way where I can achieve this without taking whole database backup through LCS or avoiding manual export/import through DMF?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Martin Dráb 238,599 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Well, there is a deprecated class for deleting transactions (SysDatabaseTransDelete), but it's not something I would rely on. You can try it, though; maybe it'll be good enough for your purposes. Exporting and importing the right entities (possibly with help of data packages) is the recommended approach.

By the way, please ask F&O-specific questions in F&O forums, such as the Finance forum. This forum is about D365 in general, which includes other products such as D365 Business Central or Sales.

Was this reply helpful? Yes No
André Arnaud de Cal... 302,670 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

A small addition to the option using the class SysDatabaseTransDelete mentioned by Martin. I do assume you don't want to delete the transactions from your Tier-2 environment. In that case, you would first need to restore a full backup and then delete the transactions. The alternative would be the (manual) export and import.

What is the exact underlying business requirement? Do you want to create a golden configuration environment or would it be a database refresh for testing purposes?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Backup without transaction data in D365 F&O

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Backup without transaction data in D365 F&O

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates