SQL on Host

  • Restoring your online Business Central database locally

    1½ years ago I wrote a blog post called Mounting a database from my online environment using SQL Server on the host. This blog post explains exactly the same thing, just end 2 end and much easier to understand (I hope), using artifacts and some new functions in BcContainerHelper. The steps involved in restoring your online Business Central database locally are: Installing/configuring prerequisites Determine artifacts based on the version of your online Business Central environment. Backup your online Business Central...

  • Running Business Central in Docker using SQL on the host

    This is not my first blog post about how to use SQL Server on the host, but it is definitely the one describing the easiest way to do it. With the latest version of BcContainerHelper you can (with one Run-BcContainer command) create a container which uses SQL Server on the host as database engine for the container. The functionality was actually enabled in version 1.0.14, but there are a few bug fixes, so I recommend that you use the latest...