We performed a comparison between MySQL, SAP IQ, and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."MySQL gives us a very user-friendly workspace in which to query the database."
"It's a good tool, a good database platform."
"The speed is very good."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"One of the best features is this solution is easy to use."
"The most valuable feature is the ease of use."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Unbeatable speed and compression with a colummn-structured relational database."
"Columnar storage allows high compression, high load rates and high query performance."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The backups are excellent."
"The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
"I think just having everything in one centralized set of databases where there is easily managed manageable."
"We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use."
"We've found it to basically be pretty problem-free."
"The most valuable feature is that it is easy to use and you don't have to do a lot of configuration."
"The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities."
"The solution is very intuitive and easy to use."
"It should have some code analytical functions. It can also have a monitoring tool."
"The technical support should be more knowledgeable and available worldwide."
"Security is a concern. MySQL could have better security features."
"It could be more secure."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"It could be a little bit simpler to use."
"The manuals or documentation could be better."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"I think the universe should be part of the Sybase IQ tool set."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"Concurrency and functional error messaging."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes."
"SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."
"I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins."
"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."
"The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient."
"Technical support could be faster."
"The upgrades are unstable."