I'm a new member to these forums, looking for some impartial expert advice about selecting a database vendor, and hoping I can find that here. This is the best forum I could figure for this request, but if there's a more appropriate one, please feel free to move the thread. I did cross-post to a couple of other database forum sites as well, so apologies in advance if you see a duplicate post.
Our situation is this: We're a company that specializes in providing Web-based consumer sales for our clients. We're currently using Sybase ASA 9, running several different instances simultaneously (typically one per client; we intend to continue that practice).
We're looking at changing databases because of:
the age of ASA 9,
the lack of real-time replication/clustering in ASA 9,
the performance of ASA 9 under stress has not been very good,
the fact that ASA isn't really intended for large-scale enterprise operations, and
our new hosting provider won't administer Sybase databases.
The leading candidates we're looking at are MySQL & SQL Server. Upgrading to Sybase ASA 11 is something of an option, but not a preferred one because of some of the reasons listed above. Oracle's license costs are beyond our budget, and the schema/functionality differences are likely more than we'd like to tackle.
What recommendations would you folks make between the two(/three)? Our primary decision-making criteria are:
Ease of migration from ASA 9 schema
Ease of data schema updates
Basic SELECT/INSERT/UPDATE performance
Replication/clustering support (especially from a performance standpoint)
Tools / Ease of administration
Ongoing cost of maintenance
Availability of technical resources (online information, personnel, consultants, etc.)
Day-to-day pros/cons of each platform
We'll be performing our own internal assessment of each database wrt these criteria as well, but unfortunately we likely won't have the time & resources to do a full port to each database prior to having to make a decision. So any insight & advice about the choice we should make, or things we should know, would be greatly appreciated. Thank you very much.