Informix Vs Sql Server

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.
dcstullerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bochgochCommented:
Personally I wouldn't worry too much about the database in relation to the numbers of users -- the application and hardware are the two major factors -- the database will undoubtedly cope (these are both enterprise RDBMS's) as long as the application is well written (and I assume your potential vendors know what they're doing) and the database is given sufficient hardware / bandwidth given your user base (and again this should be relatively straight-forward to define -- might be harder to pay for).

The decider for me (in relation to your question) is the database software and this is won hands-down by Microsoft for the following reasons:
-Availability of development / support skills.
-Level of future development.
-Functionality, both core and extended (i.e. the availabilty of third party tools, the opportunities of Reporting Services etc.)
-No-one every got fired for buying Microsoft!

However, I wouldn't use this to decide which of your applications to go with (Informix will be around for the long term and if not your vendor will need to move platform) -- only if the applications tie on all other factors should you consider this as a selection criteria.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dcstullerAuthor Commented:
One vendor stated that the reason they use Informix is because it is the best solution for the Unix os which they use for its high transaction abilities and in which Microsoft doesn't really compare.  Does this argument hold merit??
0
bochgochCommented:
Yes -- I certainly 'prefer' a UNIX hosted database (UNIX tends to be a 'cleaner' host with a more obvious relationship between processes and applications and potentially a lack of the bloatware that Microsoft suffers from). However, (much as I hate to say it) Microsoft is getting better at this sort of thing -- I understand that w2003 is a more resiliant environment than previous incarnations of windows on the server....

Given current server technologies and the move toward more smaller, flexible machines in the server cluster / farm / grid (call it what you will) the whole argument between UNIX / Microsoft servers gets clouded by issues such as load-balancing, scalability, expandibility etc....

...we come back to the earlier points -- Microsoft skills are generally easier to come-by and potentially cheaper than those associated with other platforms.

So, in summary, the argument for UNIX does hold water, but there are other factors that have bearing...

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.