We performed a comparison between IBM Informix and SQL Server based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The scalability is very good."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"Replication is a valuable feature and easy to use."
"IBM Informix benefits users with high availability and good integration capabilities."
"The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle."
"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."
"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"The security and vulnerability management are well-managed through the vendor."
"The solution is user-friendly, is a robust tool and is always reliable to users."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"It is easy to use and very stable."
"The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
"The product’s most valuable features are flexibility and scalability."
"I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server."
"Stability and usability, which is quite simple, are two of the solution's most valuable features."
"The pricing is a bit expensive."
"This solution is in need of more current tools."
"The technical support services need substantial improvement."
"I experienced poor input/output (IO) performance."
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me."
"The solution lacks some functionality."
"I would like to see backups from secondary servers."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"Performance could be improved."
"The web interface and the command line interface could be better so we could manage and build some things around an API. If we could build our own solution, our own interface, and then manage the solution through that open API, that would be better."
"Performance could be improved."
"It's difficult to make changes. It's a very complicated product in general — that's the issue."
"We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
"The security features of the solution could be better."
"With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries."
IBM Informix is ranked 15th in Relational Databases Tools with 16 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. IBM Informix is rated 8.6, while SQL Server is rated 8.4. 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 "Easy to use and provides good speed and data recovery". IBM Informix is most compared with Oracle Database, IBM Db2 Database, MySQL, MariaDB and Teradata, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and Tableau. See our IBM Informix vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.