Comment by npteljes
3 months ago
Windows can live in a VM no problem. But, depends on your use case. For GPU heavy usage, you can do GPU passthrough, and that needs a dedicated video card exclusive for the VM. If you only have light usage, like office tools, you can get by the mostly default settings.
I suggest that you just try - it's a couple of hours to install Linux and install Windows in a VM. You can try Linux dual-booting, so, no need to impact your existing system. If you end up not liking the out of the box Win VM performance, there are a couple of tricks that you can try to get substantial improvements.
OK, in my case its just boring business & CRUD apps, no GPU stuff nor gaming (btw: I find most business apps, esp. payment & accounting systems, everything else than boring - feel free to flame me for that :-D )
And can I also use MSSQL server? (which I could ditch anyway then, I guess, since we are using mainly ORM and no database-specific features)
I think you in this case, you should definitely try the VM route. Non-3d user interfaces, networking, etc should all work with no problems, MSSQL included. Do a prototype as soon as you're able, because that will answer most of your questions, and raise new ones as well.
To your second point, yes, I imagine that MSSQL could be exchanged to something else like Postgres, MariaDB or MySQL. Although, maybe you can get away with SQLite too, depending heavily on the use case of course.
Good luck!
MSSQL server has a Linux build - https://learn.microsoft.com/en-us/sql/linux/sql-server-linux...
If your CRUD apps are Winforms I had success with Wine, but you might want to try something else. I've heard good things about avaloniaui.net but never liked XAML so I haven't tried it.
Good luck!