We are currently investigating two products that are offering a Electronic Medical Record solution for our company. The two products have database servers. One resides on Informix and the other on Sql Server.
We are not sure if one is better than the other. I am asking the experts to tell me what you would choose and why. We are concerned about Informix not being supported in a year or two but yet is microsoft's product the right choice. Is there any difference in performance. We will have about 200 users hitting the database concurrently with a business critical application.