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."The application development is very user-friendly."
"The scalability is very good."
"The product offers high scalability."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"We can integrate it with any data sources as well."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"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 scalability of the solution is very good. It's able to support large amounts of data."
"It is integrated with Microsoft tools."
"The initial setup was straightforward."
"The license fee is very low."
"The solution has proven to be very stable."
"The installation is pretty straightforward."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"The backups are excellent."
"It is easy to use and very stable."
"Technical support is below our expectations currently. It could be improved."
"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."
"The product could be more economical."
"The platform’s pricing needs improvement."
"The high cost of the product is an area of concern where improvements are required."
"The query optimization and backup features should be added."
"The solution is quite expensive."
"They should improve the solution's scalability for large databases."
"Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."
"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 number of concurrent users is too limited and other databases are better than SQL in this regard."
"I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage."
"The pricing and quality of the product could be improved."
"The documentation could be much better. It's lacking right now. If there are better help pages, for even complicated queries and stuff like that that would be quite a help for users."
"With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries."
"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.