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."It supports multiple applications and business intelligence tools."
"So far, we do not have a lot of issues. It's pretty problem-free."
"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 solution's stability, performance, enhanced functionality, and replication are all great features."
"The scalability is very good."
"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."
"The stability is incredible. I have customers with uptimes of several years."
"The initial setup is pretty easy."
"SQL Server is easy to manage."
"The most valuable feature of SQL Server is the performance."
"The solution is stable."
"This solution has proven stability and operational power."
"You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
"SQL Server's performance is fine."
"We are using the net for our environment. We're using the ADF Azure data factory for our analysis services, and it is pretty good."
"The Always On tool improves the SQL server availability."
"This product could be made easier to use for beginners."
"I experienced poor input/output (IO) performance."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"I really would love to have a QT plugin."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"This solution is in need of more current tools."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"The pricing is a bit expensive."
"There is room for improvement in terms of pricing for SQL Server."
"The interface integration could be better."
"There are certain shortcomings in the scalability of the product, making it an area where improvements are required."
"The UX design of this system needs improvement."
"We pay a license fee, it could always be cheaper."
"Since this is a relational order system, scalability has a limit. If your system is very big, you need bigger servers and you have to spend more money. We scale a system up to a certain level, and then we move or shift data to the warehouse, which is NoSQL. We then do not have any bottleneck in scaling. For using this technique we are happy with it."
"The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
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.