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."
"It supports multiple applications and business intelligence tools."
"The stability is incredible. I have customers with uptimes of several years."
"So far, we do not have a lot of issues. It's pretty problem-free."
"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."
"The initial setup is pretty easy."
"IBM Informix benefits users with high availability and good integration capabilities."
"Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution."
"It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
"I think just having everything in one centralized set of databases where there is easily managed manageable."
"The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities."
"The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."
"SQL Server's Management Studio is very user friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell"
"The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query."
"Scalability, cluster ability, ease of use, ease of implementation — these are all great."
"One of the things I most like about SQL Server is the log shipping piece. This is a great feature."
"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."
"The pricing is a bit expensive."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"I would like to see backups from secondary servers."
"I really would love to have a QT plugin."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"I experienced poor input/output (IO) performance."
"The solution really doesn't add new features very often."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"Running multiple instances on the same box would be beneficial."
"The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."
"Security is an area that can be improved."
"It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load."
"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."
"The stability of the solution should be improved in the next release. Sometimes it is great, sometimes it is troublesome. I would also like data conversion and the code pages to be a bit more straightforward."
"I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups."
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.