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."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."
"Every version is faster than the previous."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"So far, we do not have a lot of issues. It's pretty problem-free."
"Replication is a valuable feature and easy to use."
"The initial setup is pretty easy."
"The scalability is very good."
"They have improved the UI and ease of accessing the database and server which is good. You can load it up and start using it from the very minute it is implemented."
"It helps with moving the design of the database into reality."
"SQL Server is easy to manage."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based. It is a very stable product, and it has got backup and recovery tools."
"We have found the feature that allows us to publish web applications to be valuable."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"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."
"I experienced poor input/output (IO) performance."
"This solution is in need of more current tools."
"The solution really doesn't add new features very often."
"The pricing is a bit expensive."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"The technical support services need substantial improvement."
"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."
"SQL Server could improve by having better usability or user guidance."
"When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."
"Its ability to handle certain kinds of large data could be improved."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."
"The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient. It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages."
"They could improve by adding the SQL format."
"Scalability of the database could be improved if it could handle increased volumes of data."
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.