Business Central: Copy your Production environment on demand using PowerShell

About a year ago I wrote an article on the new features that Microsoft introduced on Business Central Admin Center. This time, in this blog post, I will focus on Microsoft BC API for admin center, introduced with version 20. In this blog post I am going to present a PowerShell script that copies a Business Central Production environment into a Sandbox and deletes the sandbox created the day before. Moreover, I will look into adding Telemetry to these 2 operations.

Source : Business Central Musings
Read more…

PowerShell Duration

This is a really quick tip just for myself to save the script where I can easily get to it, this time a quick way to output the duration of a PowerShell script. When a script takes longer than expected, in my mind I am waiting HOURS for it to complete but it is probably just a minute or two. I’ve run into this before, where I spend WAY too much time trying to locate a good, easy way to output the duration of a script. Without further ado, here’s the PowerShell code:

Source : theDenSter
Read more…

Upload Files to SFTP via Powershell

I was asked how to upload files to SFTP from Business Central, there are several ways to do it and several posts published about it for Business Central.

In this case, without going through other Azure services, PowerApps etc., it is possible to do it directly and simply via Powershell and, given that the previous post on Powershell was quite successful, I also report this functionality in the blog.

Source : Roberto Stefanetti
Read more…

Business Central Online, quick comparison and detection of differences between table data structures using Powershell

Previously it was possible to export data structures to files (available in runtime1), the functionality was blocked from runtime 2 onwards.

Interesting function that in my opinion should be reinserted and made usable at least for On-premise.

Source : Roberto Stefanetti
Read more…