SQL Server 2022 for BC Containers

[Athystrup]

I am reaching out to inquire about the possibility of updating the SQL Server version used in the BCContainerHelper containers. Our team frequently creates new containers using .bak files provided by our customers. Recently, we've encountered compatibility issues similar to those described in issue #2903

Currently, the containers are configured with SQL Server 2019, but our customers are increasingly using SQL Server 2022, leading to version mismatch errors when restoring databases from .bak files. While we have been utilizing the workaround described in the aforementioned issue, this process adds additional overhead for our developers, who create new containers regularly.

It would significantly streamline our development process and reduce setup time if the containers could natively support SQL Server 2022, allowing for direct restoration from SQL Server 2022 .bak files.

Could you please provide information on whether there are plans to upgrade the SQL Server version in the containers to 2022? Alternatively, any guidance on a more streamlined workaround or solution would be greatly appreciated.

[gntpet]

I think you have two options:

1. Build your own generic image See original dockerfile here and adjust accordingly. Then, use useGenericImage param on New-NavContainer. But, if you want todo it for entire company, where each developers runs different OS version, it becomes a bit challenging, since you need to build multiple images, like MS does here

2. Don't use SQL server that comes with navcontainer, but use external one. I think, that's the easiest approach.

[KristofKlein]

alternative is to make an "in place" upgrade of the SQL Server within the container to another version. there are some scripts out there, that support that e.g. https://gist.github.com/m3koenig/cc9d0c53d97d249163b5cf071490114a

[pri-SiKu]

Any news on this topic? When will navcontainerhelper run with sql server 2022?