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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Copy data from product...
Finance forum

Copy data from production to sandbox.

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

Is there any option to copy all the data as it is in production environment to sandbox?

I verified info that we have in documentation and I have noticed two posibilities:

- BYOD which as far as I know copy only prepared entities, not the tables itself

- Refresh will copy current state of production and this is fine, but we want to update this data every day which is kind of trouble due to lack of users from production (there is only one user after refresh) and I believe that we cannot schedule this event.

We done refresh before and it is almost fine, but we don't need to recreate production environment on sandbox but only copy whole database once and then copy only changes which if I remember correctly is something BYOD has to offer. We can do this only once a day, at the evening, 

Thanks in advance!  

Categories:
I have the same question (0)
  • Suggested answer
    Sukrut Parab Profile Picture
    71,741 Moderator on at

    Normal refresh you do from LCS does copy only database from production to sandbox. I am not clearly getting what your problem  is with refresh DB  option in LCS. If you have problem with users , you can have  your own  script to enable all other users.

  • Community Member Profile Picture
    on at

    Ok so this would be an solution  for users issue, but what about refresh scheduling? Is there any option for this in LCS? We want to do this quite often (few times a week) so it would be the best if there would be a way to automate this.

  • Suggested answer
    Sukrut Parab Profile Picture
    71,741 Moderator on at

    There is no scheduling option as of today in LCS , it might come in future.

  • Community Member Profile Picture
    on at

    So is there any option to do this operation in D365?

  • Suggested answer
    Sukrut Parab Profile Picture
    71,741 Moderator on at

    As I said earlier answer is No. Refresh DB from LCS doesn't take time , again its depending on the size of your database. for example Db with 400+ gb takes approx. 2 hours. Please take your time to verify  answers if those helped you.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans