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."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."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"It supports multiple applications and business intelligence tools."
"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."
"It supports in-house-built applications in .NET and VB6"
"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 product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
"The most valuable feature of SQL Server is that it is easy to set up."
"The pricing of the product is very good."
"The solution is stable. It's reliable."
"It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
"SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
"It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups."
"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."
"I really would love to have a QT plugin."
"I would like to see backups from secondary servers."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"This solution is in need of more current tools."
"The pricing is a bit expensive."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"The solution is expensive. The licensing costs are high."
"The solution could use better governance on the management side, especially around data governance."
"On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
"If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good."
"I would like to see better integration between their link server and other platforms, such as IBM."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
"In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages."
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.