You are not logged in.
One of our office programs is showing its age, and I am looking at upgrading. Unfortunately, they have changed their approach and it now requires a microsoft sql server. Is there a way to run that on my arch server, through vmware or something like that? I don't want to invest in a separate windows box just for this one program.
No, there isn't an open source alternative. I've looked.
Offline
I assume that MSSQL has a feature that can't be replicated in MYSQL/PostgreSQL?
Offline
Of couse you can use kvm or VirtualBox to run a WindowsServer on your Archbox, the speed should be good enough on recent server hardware (nearly native probably) but you will need a MS Licence of course
Offline
it now requires a microsoft sql server.
You may try using Sybase ASE; for long time (until 6.0), MS SQL Server was just Sybase with MS branding and even today differences are not so big (depending, of course, on specific application's needs). I have never tried such a setup, but connecting to MSSQL with Sybase client libraries works OK, maybe you'd have luck in opposite direction.
There is a document on migrating apps from MSSQL to ASE; I know this is not the case, but there are some valuable information about differences between those RDBMSs that may help you to decide whether there are chances to succeed or not.
Offline