D365 Finance & Operations and Dynamics AX Forum

Daily Database Backup from Production

  • 1.  Daily Database Backup from Production

    Posted Jul 29, 2019 12:51 PM

    Looking for some recommendations for processing a daily export of Production data for development purposes. Developers require data in their development environments to be refreshed on a daily basis. We are currently following the process shown below.

    These steps are quite time consuming. Is there a tool that can create a database backup from Production on a daily basis? Or is there a tool that can script and automatically run some or all of of these steps?

    Current process (high level): 
    1. Refresh database from Production to Test environment
    2. Generate and export .bacpac file from Test environment
    3. Run "sqlpackage.exe /a:import..." command in separate virtual machine
    4. Export database .bak file from SQL Server Management Studio

    This is based on the Microsoft Docs process linked here:

    I'm open to any suggestions to make this process quicker and easier. Thank you all for your input!

    #Admin​​​ #FinanceandOperations

    Tim Khan
    Application Support Analyst
    DATA Communications Management Corp
    Brampton ON

If you've found this thread useful, dive deeper into User Group community content by role