We performed a comparison between Oracle Database In-Memory 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."Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot."
"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
"The solution is very fast."
"I like Oracle because it is a backward-compatible solution."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"The product offers high scalability."
"Security is the most valuable feature."
"The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications."
"The solution is configurable."
"The columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
"I have found SQL Server easy to use."
"The installation is pretty straightforward."
"The solution has the capability to scale."
"I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome."
"It works fine in terms of performance and stability."
"The technical support is good."
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"Technical support is below our expectations currently. It could be improved."
"I would like Oracle Database In-Memory to include a data replication feature."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"They should improve the solution's scalability for large databases."
"The pricing could be improved. It would ideal if it was more reasonable."
"The query optimization and backup features should be added."
"SQL Server is an expensive solution"
"The solution could offer better integration with other solutions - specifically Microsoft."
"We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."
"SQL Server could improve by increase the performance, it cannot handle large amounts of data. I did not find any additional features compared to others solutions."
"The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."
"Third-party services from Redgate should be built-in to it, like SQL Search."
"The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."
Oracle Database In-Memory is ranked 8th in Relational Databases Tools with 27 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Oracle Database In-Memory is rated 8.8, while SQL Server is rated 8.4. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Oracle Database In-Memory is most compared with SAP HANA, IBM Db2 Database, Progress OpenEdge RDBMS, MariaDB and Apache Derby, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. See our Oracle Database In-Memory 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.