Question What's your recommendation on MSSQL databases?

[q-quan]

Server operating system version

Ubuntu 24.04.3

Plesk version and microupdate number

18.0.73

I'm hosting about 10 Umbraco websites, which are based on .NET and use MSSQL databases. With .NET support for Linux and Plesk's .NET toolkit, I have been able to migrate these sites from a Windows server to a Plesk server (as it turns out, Plesk for Linux performs better, has more online support, and so on). What I haven't yet figured out is a good solution for the databases, which I currently still keep on the Windows server, due to the fact that Plesk for Linux does not support MSSQL management.

Is anyone else using MSSQL on a Linux Plesk server without managing the databases from the Plesk UI? And if so:
- Directly installing MSSQL server on their server?
- Using a MSSQL Docker container?
- Using separate MSSQL docker containers for each database to host?

Or something else entirely? Am I overlooking some convenient option?

 

[scsa20]

I haven't done it personally but the best way would be MSSQL docker container. Problem is that Plesk for Linux does not have the ability to manage MSSQL databases so it would be a lot of manual management.

If it's possible, .NET does support connecting to MySQL databases so if it's possible to migrate to that it'll be better off in the long run in terms of manageability otherwise, like I said, just running MSSQL in a docker container is fine, just need to use SSMS to manage the database (creating new databases and permissions and such).