H2 Database Engine vs. SAP Adaptive Server Enterprise (ASE)

For running application tests it's well suited. H2 [Database Engine] can replace the real-world database solution for them easily and removes the requirement to set up a a separate database instance just for running unit tests. For using in actual production application one needs to consider scale. H2 is suitable if application runs in single instance and database is located in same machine as a file where that application runs. This means the application shouldn't have a large user base. However it's easy to switch to an actual MySQL instance if the need arises, it's most likely only a configuration change and doesn't require new code.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

We use this for an inbuilt security management system, where it performs well in a scaled setup with a large volume of live data with high availability. Also, the performance is up to the mark for the large statement flow. From a DBA perspective, a lot of parameters need to be fine-tuned for the specific environment needs, which can cause overhead. Expertise is limited, and the learning curve is steep for the SAP ASE.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Can run as an in-memory database.
• Simple and quick to get started with, and is light weight (only 2MB).
• SQL compliant so it compatible with most relational databases.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• High availability and reliability.
• High performance.
• Monitoring of threshold based events.
• Security at multiple levels.
• Query plan optimization.
• Lock management.
• Access to HANA.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• There's a warning in official FAQ "Is it Reliable?"-section which makes it seem like H2 is not yet a mature product.
• If raw SQL queries are used there maybe be differences between MySQL & H2. ORM library should be used.
• Support seems to be community-based only.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• A quick button for devs to switch instances into a dev mode (eliminating logs, and such).
• Licensing is far too complicated. Simplify pricing.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Well-suited in the security domain, high performance, and low latency of the DBMS. In terms of the DBA perspective, a dedicated monitoring tool (Cockpit) helps a lot in terms of managing the database, which helps in identifying bottlenecks during performance issues. Also, it helps us to send custom alerts related to Database activities.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Incredibly responsive, saving us countless hours in troubleshooting.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

While both can run as an in-memory database, H2 Database Engine was just so much easier for us to use since we primarily use the Java stack and H2 Database Engine is also built with Java.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Doesn't take time from developers, once it's configs are set up for testing it works in everyone's development environments
• Easy to integrate in application, no need to setup separate database software, no maintenance
• No need to deal with infrastructure related issues/costs - database runs in same machine as the application that uses it.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Positive ROI.
• Ease of use with minimal training required to write high performance SQL (assumes a knowledge of SQL already).
• Ease of database administration.
• Sometimes upgrades can be difficult.
• Changing platforms can be difficult (changing say from SPARC to Intel).
• Changing operating systems can be difficult (changing from Solaris to linux).

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info