Database
-
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...
-
Mounting a database from my online environment using SQL Server on the host
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. This blog post is really a combination between the last two blog posts, https://freddysblog.com/2019/11/04/using-sql-server-on-the-host/ and https://freddysblog.com/2019/11/12/mounting-a-database-backup-from-my-online-environment-inside-a-container/. As stated in the last blog post, you can only use databases of less than 10Gb...
-
Placing the database on the host…
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. I have had quite a few partners asking me how to connect a NAV / Business Central container to a SQL Server placed on the host. Even though this sounds like a...
-
NavContainerHelper – Use an external SQL Server as database connection in a NAV container
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. If you haven’t read the first post about the NavContainerHelper, you should do so. If you have a created a SQL Server container using one of the methods described any of the blog posts:...
-
NavContainerHelper – Create a SQL Server container and restore a .bak file
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. If you haven’t read the first post about the NavContainerHelper, you should do so. The following script sample, will create a new SQL Server container and restore a NAV 2018 database backup...
-
NavContainerHelper – Create a SQL Server container with the CRONUS database from a NAV container image
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. If you haven’t read the first post about the NavContainerHelper, you should do so. The NAV container images contains SQL Express with the CRONUS Demo Database. If we want to get a...
-
NavContainerHelper – Start a NAV container and place the database files on a file share on the host computer
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. If you haven’t read the first post about the NavContainerHelper, you should do so. The database files are placed inside the container by default. If you want to copy the database to...
-
NavContainerHelper – Specify your own Database backup file to use with a NAV container
Update 2021/2/10: Microsoft stopped creating images for Docker in the summer of 2020. We now publish artifacts, which can be used to spin up containers and BcContainerHelper has replaced NavContainerHelper. This blog post reflects the old way of using NAV/BC on Docker and references NavContainerHelper, which is outdated. If you haven’t read the first post about the NavContainerHelper, you should do so. If you have a database backup file (.bak), you can specify that as parameter to the container. You...
