web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / FastTrack for Dynamics 365 forum / Copy specific legal en...
FastTrack for Dynamics 365 forum
Suggested Answer

Copy specific legal entity from PROD to Sandbox environment D365FSCM

(0) ShareShare
ReportReport
Posted on by Murali254. 20
Hello Experts,

I need to copy only one specific legal entity data from PROD to Sandbox environment (D365F SCM).

Could anyone please suggest the best approach to achieve this

Thank you
Categories:
Engaging with FastTrack
  • Suggested answer
    Adis Profile Picture
    Adis 6,902 Super User 2026 Season 2 on at
    Hello,
     
    There is no option to do this. You can only copy the whole db, but not parts of it. Especially, since the data isnt seperated by legal entities in different tables. In most cases you have a table where one column indicates to which legal entity the row belongs. Its not in all tables but most of them.
     
    So, copying the whole db is the solution. Question is, why do you want to copy only one legal entity?
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • Murali254. Profile Picture
    Murali254. 20 on at
    Hi Adis,

    Thank you for your response!.

    The sandbox will be given to specific users where they have sys admin access. I can say, Two different groups are in the same tenant. We want to restrict other legal entity data.

    Regards,
    Murali
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,115 Super User 2026 Season 2 on at
    H Murali,
     
    As an alternative, you can create a script that will delete transactions and/or master data after the copy from prod to a sandbox.

    You can also consider using other security roles and limit access by assigning organizations to the user associated security roles.
  • Murali254. Profile Picture
    Murali254. 20 on at
    Hi André, 

    Thank you for your input. I have one additional question regarding the Power BI workspace. The workspace is intended to be dedicated to a single team, and users should not be able to connect to other environments such as UAT or PROD from within that workspace. However, the users currently have broader access rights. Since these permissions are controlled at the Entra ID level rather than within Finance & Operations, could you please provide guidance on how to best manage or restrict this access?
  • Aayush Tiwari Profile Picture
    Aayush Tiwari 384 on at

    @Murali254. 

    I would suggest to start a new thread for your workspace related question.

     

    Regards

    Aayush Tiwari

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > FastTrack for Dynamics 365

#1
Aayush Tiwari Profile Picture

Aayush Tiwari 16

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 6 Super User 2026 Season 2

#3
Navneeth Nagrajan Profile Picture

Navneeth Nagrajan 2 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans