We changed our name from IT Central Station: Here's why

IBM Informix vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
IBM Informix Logo
2,126 views|1,322 comparisons
SQL Server Logo
19,554 views|14,983 comparisons
Featured Review
Find out what your peers are saying about IBM Informix vs. SQL Server and other solutions. Updated: January 2022.
564,143 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
"The solution's stability, performance, enhanced functionality, and replication are all great features.""For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain.""The initial setup is pretty easy.""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 stability is incredible. I have customers with uptimes of several years."

More IBM Informix Pros →

"The solution can be used for a host of applications.""SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.""The backups are excellent.""A valuable feature of the solution is that it is comparatively simpler to manage than Oracle.""Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.""From a security perspective, we have no complaints.""If you need to, you can scale the solution very easily.""It is easy to use and easy to perform a backup."

More SQL Server Pros →

Cons
"The pricing is a bit expensive.""The solution really doesn't add new features very often.""The solution lacks some functionality.""Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language.""There should be more intelligence surrounding discovering data to be able to automatically create indexes.""I would like to see backups from secondary servers.""This product could be made easier to use for beginners."

More IBM Informix Cons →

"As we have faced problems with the solution in both the past and present, I feel it could be more stable.""With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries.""The solution could be better when it comes to security.""The solution needs to be more secure. It's lacking, compared to, for example, Oracle.""I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements.""The solution is rather expensive.""Price could be cheaper, and access to reporting tools should be better.""The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."

More SQL Server Cons →

Pricing and Cost Advice
  • "The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
  • "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.
    564,143 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: 
    I have found SQL Server easy to use.
    Top Answer: 
    SQL Server could improve by having better usability or user guidance.
    Ranking
    8th
    Views
    2,126
    Comparisons
    1,322
    Reviews
    6
    Average Words per Review
    594
    Rating
    9.0
    1st
    Views
    19,554
    Comparisons
    14,983
    Reviews
    135
    Average Words per Review
    462
    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 Company32%
    Comms Service Provider23%
    Government7%
    Retailer6%
    REVIEWERS
    Financial Services Firm18%
    Computer Software Company13%
    Manufacturing Company11%
    Comms Service Provider5%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider22%
    Financial Services Firm7%
    Government5%
    Company Size
    REVIEWERS
    Small Business58%
    Midsize Enterprise8%
    Large Enterprise33%
    REVIEWERS
    Small Business43%
    Midsize Enterprise21%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    Find out what your peers are saying about IBM Informix vs. SQL Server and other solutions. Updated: January 2022.
    564,143 professionals have used our research since 2012.

    IBM Informix is ranked 8th in Relational Databases with 8 reviews while SQL Server is ranked 1st in Relational Databases with 143 reviews. IBM Informix is rated 9.2, while SQL Server is rated 8.2. The top reviewer of IBM Informix writes "Many embedded functionalities of the engine allow for significant savings on complex developments and maintenance". On the other hand, the top reviewer of SQL Server writes "Veteran solution with critical log shipping feature". IBM Informix is most compared with Oracle Database, IBM Db2 Database, MySQL, Oracle Database In-Memory and Oracle Multitenant, 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.