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 :
Finance | Project Operations, Human Resources, ...
Answered

Automatic export/import DB

(0) ShareShare
ReportReport
Posted on by 4,131

Hi,

Is there any way to set up a regular Azure DevOps pipeline to export DB from one environment and import DB into another environment?

Thanks,

I have the same question (0)
  • Verified answer
    Sergei Minozhenko Profile Picture
    23,093 on at

    Hi Yuji

    Probably you are looking for Database movement API (docs.microsoft.com/.../dbmovement-api-overview), but it's under preview at the moment and list of actions is quite limited.

    Also, you can take a look at d365fo.tools (github.com/.../Invoke-D365LcsDatabaseRefresh.md)

    BR, Sergei

  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    Yes, it's possible.

    You can use the new LCS API which is in preview: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/api/dbmovement-api-authentication

    You can trigger any PowerShell scripts from ADO build pipeline. So you just need to create such PowerShell scripts that export / import database. If you take this path you should check d365fo.tools PowerShell module: https://github.com/d365collaborative/d365fo.tools

  • Yuji Profile Picture
    4,131 on at

    Thanks for the information. I may just plan to use Power Automation to consume the DB Movement API, however is it possible to call the Power Automation endpoint from Azure Release Pipeline?

  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    That question is not so much related to D365FO anymore, so perhaps you can look into Power Automate and Azure DevOps communities.

    Here's a tutorial for creating a custom trigger in Power Automate and calling it from your app: https://flow.microsoft.com/en-us/blog/call-flow-restapi/

    So, in your scenario you would implement this trigger, and some program/script that calls it, and then call that program from the release pipeline.

  • Yuji Profile Picture
    4,131 on at
    [quote]You can trigger any PowerShell scripts from ADO build pipeline. So you just need to create such PowerShell scripts that export / import database. If you take this path you should check d365fo.tools PowerShell module: https://github.com/d365collaborative/d365fo.tools[/quote]

    To use d365fo.tools, I need to have a Tier 1 environment, right? I am not sure how to install these tool on Azure DevOps pipeline.

  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    You can install and run D365FO.tools scripts on the build VM as well.

    Either put a PowerShell script on the build VM, and inside that script, install d365fo.tools and run your commands, or set up this PowerShell command directly in the build pipeline settings.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans