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."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."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"The initial setup is pretty easy."
"Every version is faster than the previous."
"The stability is incredible. I have customers with uptimes of several years."
"IBM Informix benefits users with high availability and good integration capabilities."
"It supports in-house-built applications in .NET and VB6"
"Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job."
"The backups are excellent."
"The solution offers very high performance."
"One of the most valuable features of SQL Server is that it's easy to use."
"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."
"Stability and usability, which is quite simple, are two of the solution's most valuable features."
"We have many users, between 50 and 100 using the SQL Server product."
"I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it. You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers."
"The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process."
"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."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"This product could be made easier to use for beginners."
"I would like to see backups from secondary servers."
"The technical support services need substantial improvement."
"The price could be better. It costs a lot, and competing databases like Postgres are free."
"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."
"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."
"The solution could be better integrated with the SQL Server Studio tool."
"I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements."
"I would say that people should know how to get a SQL setup in place since it might be an area where they lack when it comes to the solution."
"An area for improvement would be the SQL Server process monitoring, which is quite basic and could sustain more information."
"The price could be better. In the next release, it would be better if the database was more easily extendable."
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.