My client wants to use MSSQL with OpenEMR. We dont have any other option for backend. Please help. Request to provide reference and feedback.
If you are running on a windows server you can still run a WAMP stack and run mySQL.
Project uses adodb so in theory with some (or maybe lot of) work you could use mssql. Otherwise if you know mssql well and are willing to take a performance hit, setup linked server to mysql. Then emr will talk to mysql and your client can have their mssql interface.
Be open to the possibility that odbc clients may expose some linked mssql tables as read only.