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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Creating an new enivronment as copy of Production and update-it daily with production database.

(0) ShareShare
ReportReport
Posted on by 85

Hello all,

I want to create an enivronment as a copy of Production and i want this environment to be update-ed daily from production with production database.

Can anyone help me to do that and what steps should i follow?

Thank u in advance.

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    50,243 Super User 2025 Season 2 on at

    Are you referring to On-Prem or Saas?

  • YUN ZHU Profile Picture
    95,548 Super User 2025 Season 2 on at

    Hi, if you are on the On-Premises version, you can use export to a data file and import from a data file as in NAV. 

    Or you can use the SQL backup strategy to back up the database for the production environment every day.

    pastedimage1625615935457v1.png

    If you are on the SaaS version, you can create a Sandbox environment by copying the Production environment.

    pastedimage1625616151489v2.png

    If you don't want to run it manually every day, you can use the Admin API. But please note that the capacity of SaaS is not unlimited, personally do not recommend this.

    https://github.com/microsoft/BCTech/blob/master/samples/AdminCenterApi/PowerShell/Environments.ps1

    pastedimage1625616275182v3.png

    Hope this will help,.

    ZHU

  • Nertila Tila12 Profile Picture
    85 on at

    Hi Yun,

    Thanks for answering. I have a question:

    Can the process that i have described on the post be implemented to create an extension with an API , smthg like this?

  • Suggested answer
    JAngle Profile Picture
    133 on at

    What’s the reason for needing it out of interest? Database or company this type of idea could work. You could use standard posting actions once the data is in the other database: joshanglesea.wordpress.com/.../

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans