Mssql server on ubuntu?

dev
1

hi,

i wonder if anyone has installed ms sql server onto ubunto (16.04 or 18.04) and enabled tcp/ip access.

thanks.

2

Rather than installing MS SQL on Ubuntu, here we use the MS SQL Docker image for our dev work, as we all use Ubuntu here.

1 Like
3

Interesting, is MS SQL Server Docker image production ready? If youā€™re not using it for production yet and our customers may not starting to use it yet, how do we address DevOps here? Thanks.

4

TBH I donā€™t knowā€¦ I assumed (yeah I know) that you were looking for a way of developing whilst on Ubuntu without having to run huge VMsā€¦

We run MS SQL on a ā€˜normalā€™ Windows server in GCP.

Our CF Apps run in Docker images, so we run MS SQL in Docker so that we can run it all in docker-compose.

1 Like
5

In theory it should be production ready:
https://hub.docker.com/r/microsoft/mssql-server-linux/

The GA release states

GA = General Availability - when the version is officially available and supported.

You should also note that this is not just a ā€œfreeā€ version of MS SQL, you still have to have a proper license:

To specify the edition, use the MSSQL_PID environment variable. Details can be found in the ā€œEnvironment Variablesā€ section below.
SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer Edition cannot be used in a production environment.

1 Like
6

How about MS SQL Server Docker image requirements? For its regular one on ubuntu, ubuntu has to be 16.04 release and the host has to have at least 2 GB of RAM. Thanks.

7

Iā€™m opting for the choice of dev or free version for now, concern for free version is if we need to deploy whatever weā€™re doing now under such a version would we run into some serious issue when applying them to production MS SQL server down the roadā€¦

8

Having to run 10-15 Lucee images as well as MS SQL and Redis; weā€™re lucky here in that our laptops have 16GB of RAM.

Itā€™s a pain to start the environment and run the healthcheck; at the moment it takes ~10 mins when Iā€™m running the full stack.

But once itā€™s running, I donā€™t really see any issues during the dayā€¦

1 Like
9

I hear you, but my current laptop has 8GB of RAM, I wish itā€™s 16.