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."Every version is faster than the previous."
"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."
"It supports in-house-built applications in .NET and VB6"
"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 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 initial setup is pretty easy."
"IBM Informix benefits users with high availability and good integration capabilities."
"SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation."
"SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm."
"I find query optimization to be highly valuable for data management. Additionally, drag-and-drop query creation greatly facilitates data management tasks."
"SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based."
"Stability and usability, which is quite simple, are two of the solution's most valuable features."
"It's more user-friendly than most databases."
"The technical support is good."
"There is a lot of information about the solution readily available online."
"The solution lacks some functionality."
"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."
"I really would love to have a QT plugin."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"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."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"The solution really doesn't add new features very often."
"Microsoft support is an issue unto itself."
"CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
"The only item which I can list is application failure during Integration Services debugging, when restarting a process flow. In a number of instances the solutions fails. I have not given this much thought and simply stop and start the debugging service rather than restarting."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"The solution could offer more integration with other platforms."
"Sometimes, the tool doesn't support all the native features, and because of this, our company has to customize it to meet our requirements, which is a challenging process for our company's engineers."
"When transferring data from the SQL Server to Excel, the data types are not copied correctly. This issue might be associated with the formatting of the data types."
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.