I am loathe to respond to this post but here goes. I've already said my "Hail Mary's."

When I read this my mind went immediately to Dante's Divine Comedy: I am still languishing in purgatory for mentioning SQL Server 8 months ago. I can only imagine which level you are going to. ROFL.

The decision to go to SQL Server is not an easy one for any developer. I know it was a serious, but necessary decision. One of the reasons developers choose a RDBMS platform/OS is market penetration, which equals familiarity for the end users and support staff. This makes for lower support costs.

Most of the Physicians who use AC are small practices. I doubt having a ubuntu server in their WINDOWS environment would be a pleasant experience.

Please see the following article which compares MySQL 5.0 to SQL Server 2005
http://discuss.joelonsoftware.com/default.asp?design.4.594808.40

Originally Posted by nsmurali1
Dr. Bertman:
Kindly review the real utility of mysql. It is a superior product compared to MSSQL
Superior is an objective term. Developers and Architects base their decisions many criteria, but a blanket statement without qualification is....
1) It will provide robust database server at low cost
SQL Server Express, the entry level server of AC4 is free. I don't think there is a lower cost than free.
2) All platforms including Linux, most versions of windows including 2000 and earlier supported. Hence a ubuntu machine can potentially work as a AC server for large practices.It avoids the hassles of windows server installation. My windows server installations have never been a hassle. Bert also has some expertise installing SQL Server
Your program will run at least 10times faster and not crash
10 times faster? I doubt that ANY RDBS is 10X faster than any other database.
3) Highly secure Remote trouble shooting for ubuntu linux platform is easier than for windows.
Aren't we mixing apples and oranges here? You are talking about trouble shooting the OS. That is not the vendors responsibility. I can remote into any desktop using JaaduRDP or JaaduVNC on my iPhone, from any where.
4) Ubuntu machine is easy to configure as a highly secure file and database server for internet access of AC.
5) AC can then function like an enterprise product.You can also sell the hardware+software through interested resellers. A better business model.
6) Avoids the trap of frequent hardware and OS upgrades imposed by MS software.


Last edited by gkfahnbulleh; 03/09/2009 4:34 PM.
"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler