Coming from a background of working with Microsoft Dynamics GP, I am used to being able to automate the copy of production to test using SQL Server Agent. Since moving to working with Microsoft Dynamics 365 Business Central this is not something I’ve been able to automate as Business Central is cloud-based rather than on-premise and we don’t have the same access to the database.
Earlier in December last year, Andrew Wingate published an article on creating a fresh sandbox copy of production every night using Power Automate.
I’ve been doing some work with Power Automate over the last year or so, so this is an interesting approach and one I am going to take a look into when I have time.
Full details are available in Peter’s article.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.