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 solution's stability, performance, enhanced functionality, and replication are all great features."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"Every version is faster than the previous."
"Replication is a valuable feature and easy to use."
"IBM Informix benefits users with high availability and good integration capabilities."
"The stability is incredible. I have customers with uptimes of several years."
"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 initial setup is pretty easy."
"I have seen that this is a very stable product."
"Since we can automate most of our tasks, it means that the management is very easy."
"I have found the whole solution with all its features wonderful."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."
"SQL is stable."
"We have many users, between 50 and 100 using the SQL Server product."
"SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
"The pricing is a bit expensive."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"I really would love to have a QT plugin."
"I would like to see backups from secondary servers."
"The technical support services need substantial improvement."
"The solution really doesn't add new features very often."
"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."
"SQL Server has good performance, but it could be better."
"The number of concurrent users is too limited and other databases are better than SQL in this regard."
"I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
"Performance could be improved."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"I want to see one improvement and this involves the replication between the DC and DR."
"The pricing could be better."
IBM Informix is ranked 14th 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.