Update- Beta program for SQL Server on Windows container is suspended.

Published Jul 05 2021 08:40 AM 12.1K Views
Microsoft

As you may be aware, the SQL Server on Windows Containers Beta program began in 2017. It has remained in Beta mode meant for only test and development environment until now. Due to the existing ecosystem challenges and usage patterns we have decided to suspend the SQL Server on Windows Containers beta program for foreseeable future. Should the circumstances change, we will revisit the decision at appropriate time and make relevant announcement.

 

Hence with immediate effect, the docker hub repos  "microsoft/mssql-server-windows-express" and

"microsoft/mssql-server-windows-developer" and the tags within these repos will be deleted and images from these repos will not be available for download going forward.  We look forward to your continued support and feedback to help us improve.

 

SQL Server on Linux containers continue to be supported for production environment. This announcement only affects SQL Server on Windows container that was in Beta mode until now. 

 

Thanks,

Amit Khandelwal 

Senior Program Manager

12 Comments

Could you please not delete those repos and images? That is going to break stuff. Folks have builds that depend on these images. At least give some warning rather than "immediate effect".

 

Yes, SQL Server on Linux is much easier to work with but for some legacy Windows apps that had to run on Server Core, having another Windows container with SQL in it is the only option (seeing as running mixed Windows and Linux containers is pretty much unsupported or very unreliable).

 

David

Occasional Visitor

@David Gardiner what did you mean by mixed Windows and Linux containers. Both Windows and Linux containers running on a Windows Server or Windows containers on a Windows host and Linux on a Linux host? What kind of issues did you have on your mind? 

 

I currently have RabbitMQ and Postgres running on a Linux host and .Net Framework services on a Windows host. I did struggle a bit to make that work.

I was referring to running mixed Windows and Linux containers on a single Windows host. I know there was some support added for an older version of docker-compose a few years ago but last time I checked that hadn't progressed, and there also were issues building images in that scenario.

 

I was also hoping to be able to run images as part of an Azure Pipeline 'integration test' but again the ability to run Windows and Linux containers is missing.

 

 

Regular Visitor

 

I want to run and build Linux and Windows (LCOW) containers simultaneously on the journey to 100% .NET cross-platform.

 

The mixed-mode Windows/Linux is NOT great on docker desktop; people use Windows containers and Linux containers simultaneously.

I did open an issue a long time ago, https://github.com/docker/roadmap/issues/79 but docker has not taken action. The M1 is more important, and I still believe there is a need for Windows and Linux containers on Windows/WSL with docker-compose. 

 

Suspending MSSQL on windows containers is not great.

Bart Plasmeijer

Microsoft

I do understand the passion for SQL Server on Windows containers, but as you can see the tags and images were not updated in the last three years for various reasons. One of the reason to delete the mssql-server-windows-developer and mssql-server-windows-express repos and images in those repos is that going forward we do not want any new users and customers downloading it. But if you already have it and are using it you can continue using it and also custom build your SQL Server on Windows images but they are not going be supported as was the case with the images on mssql-server-windows-developer and mssql-server-windows-express as they were in Beta mode which was meant for development and test environment's only.

Occasional Visitor

Hi - this means you've ported the SSDT tools to Linux, right?  Because if not, this change causes significant difficulty to your SSDT customers using containers to build their SQL Server databases.

 

Edit Whelp - it appears that DacFx and SqlPackage have been out for Mac and Linux for about 2 years now...  DacFx and SqlPackage release notes - SQL Server | Microsoft Docs

Occasional Visitor

In the book "Hands-On Data Virtualization with Polybase" you learn how to install SQL Server on Windows Server Core running on Docker Windows, so you don't rely on Microsoft.

Regular Visitor

I agree with @amvin87, and thanks for the feedback, we did create our own image based on Windows Server Core.

Bart

Occasional Visitor

If a tree falls in the forest...   why would anyone care which OS a container is? That defeats the entire purpose. 

 

Occasional Visitor

@kevtothec it matters when running containers with different operating systems on the same host doesn't work well yet, and, for example, there is significant tooling for SQL Server that is still Windows only (such as building `.dacpac` files from source via SSDT rather than from a running server).

 

In the end, this is frustrating, but I suppose we'll just have to make our own dockerfile for this.  This just seems like a waste since this one was perfectly good for using with CI.

Occasional Visitor

"I have binaries that run only on a particular vendor's operation system" = Don't use containers.  

 

 

For anyone interested, I have created SQL on Windows container images here (dev edition) and here (express edition), the sources are here, and I also blogged about it. I'd be happy to create more images for older versions if needed, but I certainly will update the repo with the latest CUs

%3CLINGO-SUB%20id%3D%22lingo-sub-2516639%22%20slang%3D%22en-US%22%3EUpdate-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2516639%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20may%20be%20aware%2C%20the%20SQL%20Server%20on%20Windows%20Containers%20Beta%20program%20began%20in%202017.%20It%20has%20remained%20in%20Beta%20mode%20meant%20for%20only%20test%20and%20development%20environment%20until%20now.%20Due%20to%20the%20existing%20ecosystem%20challenges%20and%20usage%20patterns%20we%20have%20decided%20to%20suspend%20the%20SQL%20Server%20on%20Windows%20Containers%20beta%20program%20for%20foreseeable%20future.%20Should%20the%20circumstances%20change%2C%20we%20will%20revisit%20the%20decision%20at%20appropriate%20time%20and%20make%20relevant%20announcement.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHence%20with%20immediate%20effect%2C%20the%20docker%20hub%20repos%26nbsp%3B%20%22%3CA%20href%3D%22https%3A%2F%2Fhub.docker.com%2Fr%2Fmicrosoft%2Fmssql-server-windows-express%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Emicrosoft%2Fmssql-server-windows-express%3C%2FA%3E%22%20and%3C%2FP%3E%0A%3CP%3E%22%3CA%20href%3D%22https%3A%2F%2Fhub.docker.com%2Fr%2Fmicrosoft%2Fmssql-server-windows-developer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Emicrosoft%2Fmssql-server-windows-developer%3C%2FA%3E%22%20and%20the%20tags%20within%20these%20repos%20will%20be%20deleted%20and%20images%20from%20these%20repos%20will%20not%20be%20available%20for%20download%20going%20forward.%26nbsp%3B%20We%20look%20forward%20to%20your%20continued%20support%20and%20feedback%20to%20help%20us%20improve.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESQL%20Server%20on%20Linux%20containers%20continue%20to%20be%20supported%20for%20production%20environment.%20This%20announcement%20only%20affects%20SQL%20Server%20on%20Windows%20container%20that%20was%20in%20Beta%20mode%20until%20now.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EAmit%20Khandelwal%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESenior%20Program%20Manager%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2516639%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLReleases%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQLServerTiger%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2517443%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2517443%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20you%20please%20not%20delete%20those%20repos%20and%20images%3F%20That%20is%20going%20to%20break%20stuff.%20Folks%20have%20builds%20that%20depend%20on%20these%20images.%20At%20least%20give%20some%20warning%20rather%20than%20%22immediate%20effect%22.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20SQL%20Server%20on%20Linux%20is%20much%20easier%20to%20work%20with%20but%20for%20some%20legacy%20Windows%20apps%20that%20had%20to%20run%20on%20Server%20Core%2C%20having%20another%20Windows%20container%20with%20SQL%20in%20it%20is%20the%20only%20option%20(seeing%20as%20running%20mixed%20Windows%20and%20Linux%20containers%20is%20pretty%20much%20unsupported%20or%20very%20unreliable).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2518049%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2518049%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F44334%22%20target%3D%22_blank%22%3E%40David%20Gardiner%3C%2FA%3E%26nbsp%3Bwhat%20did%20you%20mean%20by%20mixed%20%3CSPAN%3EWindows%20and%20Linux%20containers.%20Both%20Windows%20and%20Linux%20containers%20running%20on%20a%20Windows%20Server%20or%20Windows%20containers%20on%20a%20Windows%20host%20and%20Linux%20on%20a%20Linux%20host%3F%20What%20kind%20of%20issues%20did%20you%20have%20on%20your%20mind%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20RabbitMQ%20and%20Postgres%20running%20on%20a%20Linux%20host%20and%20.Net%20Framework%20services%20on%20a%20Windows%20host.%20I%20did%20struggle%20a%20bit%20to%20make%20that%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2518067%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2518067%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20referring%20to%20running%20mixed%20Windows%20and%20Linux%20containers%20on%20a%20single%20Windows%20host.%20I%20know%20there%20was%20some%20support%20added%20for%20an%20older%20version%20of%20docker-compose%20a%20few%20years%20ago%20but%20last%20time%20I%20checked%20that%20hadn't%20progressed%2C%20and%20there%20also%20were%20issues%20building%20images%20in%20that%20scenario.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20was%20also%20hoping%20to%20be%20able%20to%20run%20images%20as%20part%20of%20an%20Azure%20Pipeline%20'integration%20test'%20but%20again%20the%20ability%20to%20run%20Windows%20and%20Linux%20containers%20is%20missing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2519036%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2519036%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20run%20and%20build%20Linux%20and%20Windows%20(LCOW)%20containers%20simultaneously%20on%20the%20journey%20to%20100%25%20.NET%20cross-platform.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20mixed-mode%20Windows%2FLinux%20is%20NOT%20great%20on%20docker%20desktop%3B%20people%20use%20Windows%20containers%20and%20Linux%20containers%20simultaneously.%3C%2FP%3E%3CP%3EI%20did%20open%20an%20issue%20a%20long%20time%20ago%2C%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdocker%2Froadmap%2Fissues%2F79%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fdocker%2Froadmap%2Fissues%2F79%3C%2FA%3E%26nbsp%3Bbut%20docker%20has%20not%20taken%20action.%20The%20M1%20is%20more%20important%2C%20and%20I%20still%20believe%20there%20is%20a%20need%20for%20Windows%20and%20Linux%20containers%20on%20Windows%2FWSL%20with%20docker-compose.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuspending%20MSSQL%20on%20windows%20containers%20is%20not%20great.%3C%2FP%3E%3CP%3EBart%20Plasmeijer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2519126%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2519126%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20understand%20the%20passion%20for%20SQL%20Server%20on%20Windows%20containers%2C%20but%20as%20you%20can%20see%20the%20tags%20and%20images%20were%20not%20updated%20in%20the%20last%20three%20years%20for%20various%20reasons.%20One%20of%20the%20reason%20to%20delete%20the%20mssql-server-windows-developer%20and%20mssql-server-windows-express%20repos%20and%20images%20in%20those%20repos%20is%20that%20going%20forward%20we%20do%20not%20want%20any%20new%20users%20and%20customers%20downloading%20it.%20But%20if%20you%20already%20have%20it%20and%20are%20using%20it%20you%20can%20continue%20using%20it%20and%20also%20custom%20build%20your%20SQL%20Server%20on%20Windows%20images%20but%20they%20are%20not%20going%20be%20supported%20as%20was%20the%20case%20with%20the%20images%20on%20mssql-server-windows-developer%20and%20mssql-server-windows-express%20as%20they%20were%20in%20Beta%20mode%20which%20was%20meant%20for%20development%20and%20test%20environment's%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2520842%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2520842%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20this%20means%20you've%20ported%20the%20SSDT%20tools%20to%20Linux%2C%20right%3F%26nbsp%3B%20Because%20if%20not%2C%20this%20change%20causes%20significant%20difficulty%20to%20your%20SSDT%20customers%20using%20containers%20to%20build%20their%20SQL%20Server%20databases.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2521102%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2521102%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20book%20%22Hands-On%20Data%20Virtualization%20with%20Polybase%22%20you%20learn%20how%20to%20install%20SQL%20Server%20on%20Windows%20Server%20Core%20running%20on%20Docker%20Windows%2C%20so%20you%20don't%20rely%20on%20Microsoft.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2522598%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2522598%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F825574%22%20target%3D%22_blank%22%3E%40amvin87%3C%2FA%3E%2C%20and%20thanks%20for%20the%20feedback%2C%20we%20did%20create%20our%20own%20image%20based%20on%26nbsp%3B%3CSPAN%3EWindows%20Server%20Core.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2525908%22%20slang%3D%22en-US%22%3ERe%3A%20Update-%20Beta%20program%20for%20SQL%20Server%20on%20Windows%20container%20is%20suspended.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2525908%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20a%20tree%20falls%20in%20the%20forest...%26nbsp%3B%20%26nbsp%3Bwhy%20would%20anyone%20care%20which%20OS%20a%20container%20is%3F%20That%20defeats%20the%20entire%20purpose.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Jul 05 2021 12:07 PM
Updated by: