Tag Archives: Database

Mounting a database from my online environment using SQL Server on the host

Posted on by
10

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 in size inside the container due to SQL Express. This blog post will explain how to get past that problem. Continue reading →

NavContainerHelper – Use an external SQL Server as database connection in a NAV container

Posted on by
Reply

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:

Then you will have the variables $databaseServer, $databaseInstance, $databaseName and $databaseCredential pointing to a database you can use to start up a NAV container. These parameters can be given directly to New-NavContainer. Continue reading →

NavContainerHelper – Create a SQL Server container and restore a .bak file

Posted on by
6

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 file (Demo Database NAV (11-0).bak) placed on the host in a folder called c:\temp\navdbfiles. Continue reading →

NavContainerHelper – Create a SQL Server container with the CRONUS database from a NAV container image

Posted on by
Reply

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 copy of the databases from a NAV container image, we can override the navstart.ps1 script with a script, which basically just starts the SQL Server, takes the database offline and copies the database files to a folder. Continue reading →

NavContainerHelper – Start a NAV container and place the database files on a file share on the host computer

Posted on by
Reply

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 a share on the Docker host, you can override the SetupDatabase.ps1 script by creating a file called SetupDatabase.ps1, specify that in myScripts.ps1 to New-NavContainer and share a folder on the host, which can host the DB files. Continue reading →

NavContainerHelper – Specify your own Database backup file to use with a NAV container

Posted on by
Reply

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 can specify the bakfile using a secure URL. Read this for information about how to create a secure url for a file. Continue reading →