IT Central Station is now PeerSpot: Here's why

IBM Informix vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
2,314 views|1,477 comparisons
Microsoft Logo
20,336 views|15,716 comparisons
Featured Review
Buyer's Guide
IBM Informix vs. SQL Server
May 2022
Find out what your peers are saying about IBM Informix vs. SQL Server and other solutions. Updated: May 2022.
608,010 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Replication is a valuable feature and easy to use.""So far, we do not have a lot of issues. It's pretty problem-free.""The scalability is very good.""The initial setup is pretty easy.""The stability is incredible. I have customers with uptimes of several years.""The solution's stability, performance, enhanced functionality, and replication are all great features."

More IBM Informix Pros →

"SQL is stable.""We're satisfied with the stability.""It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature.""Backups hardly get corrupt.""This solution is user-friendly and easy to understand.""I have found the whole solution with all its features wonderful.""SQL Server and their offers are very good. You can switch over, export, and do other things.""I believe Always On is the most valuable feature. It's also easy to use and not very tricky."

More SQL Server Pros →

Cons
"The solution lacks some functionality.""The solution really doesn't add new features very often.""I would like to see backups from secondary servers.""The pricing is a bit expensive.""This product could be made easier to use for beginners.""There should be more intelligence surrounding discovering data to be able to automatically create indexes."

More IBM Informix Cons →

"For small-scale businesses, Microsoft could improve by removing some limits in SQL Express.""SQL Server could be improved with cheaper licensing because it's very expensive.""We would like to have a common storage option in the SQL Server. This option is available in Oracle Database. It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage.""We experience latency at times when there is a lot of data being processed.""I am fine with the pricing, but pricing is an area that can always be improved.""The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions.""There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version.""We have no vision. We don't know when or how we have been hacked."

More SQL Server Cons →

Pricing and Cost Advice
  • "I am not aware of the licensing costs or terms."
  • More IBM Informix Pricing and Cost Advice →

  • "SQL Server is a cost-effective solution for a small database."
  • "Pricing is reasonable for small organizations, but the scaling increases the price."
  • "We didn't have any licensing costs for SQL Server."
  • "We pay approximately $12,000 USD per month for both the server and the license."
  • "The price could be cheaper."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    608,010 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The stability is incredible. I have customers with uptimes of several years.
    Top Answer:This product could be made easier to use for beginners. As I have worked with it for quite a while, it is not difficult for me. However, some of my customers complain that it is too difficult to… more »
    Top Answer:We're satisfied with the stability.
    Top Answer:Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
    Ranking
    8th
    Views
    2,314
    Comparisons
    1,477
    Reviews
    7
    Average Words per Review
    454
    Rating
    9.0
    1st
    Views
    20,336
    Comparisons
    15,716
    Reviews
    172
    Average Words per Review
    451
    Rating
    8.2
    Comparisons
    Also Known As
    Informix
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview
    Informix is one of the most widely used database servers offering high levels of performance and availability, distinctive capabilities, & minimal overhead.

    SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

    Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

    Offer
    Learn more about IBM Informix
    Learn more about SQL Server
    Sample Customers
    Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
    Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company29%
    Comms Service Provider21%
    Government7%
    Retailer6%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider21%
    Financial Services Firm8%
    Government6%
    Company Size
    REVIEWERS
    Small Business58%
    Midsize Enterprise8%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise22%
    Large Enterprise61%
    REVIEWERS
    Small Business43%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise16%
    Large Enterprise63%
    Buyer's Guide
    IBM Informix vs. SQL Server
    May 2022
    Find out what your peers are saying about IBM Informix vs. SQL Server and other solutions. Updated: May 2022.
    608,010 professionals have used our research since 2012.

    IBM Informix is ranked 8th in Relational Databases with 7 reviews while SQL Server is ranked 1st in Relational Databases with 172 reviews. IBM Informix is rated 9.0, while SQL Server is rated 8.2. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". IBM Informix is most compared with Oracle Database, IBM Db2 Database, MySQL, Oracle Database In-Memory and Teradata, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and Vertica. See our IBM Informix vs. SQL Server report.

    See our list of best Relational Databases vendors.

    We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.