Compare Apache Derby vs. SQL Server
Use Apache Derby? Share your opinion.
 | Anonymous User Information Systems Manager at a aerospace/defense firm |
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: March 2021.
475,291 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Information Not Available
"SQL Server is a cost-effective solution for a small database."
"Pricing is reasonable for small organizations, but the scaling increases the price."
"We didn't have any licensing costs for SQL Server."
"We pay approximately $12,000 USD per month for both the server and the license."
"The price could be cheaper."
"Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
"We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
"With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
475,291 professionals have used our research since 2012.
Ask a question
Earn 20 points
Top Answer: I don't have any details on the licensing in terms of any details or costs. It's not an aspect of the solution I directly deal with.
Top Answer: The solution was delivered to us, and we really don't interface with the solution directly. I can't speak to any features that are missing. The only people that can use it directly are developers… more »
Views
1,214
Comparisons
1,136
Reviews
0
Average Words per Review
0
Rating
N/A
Views
23,153
Comparisons
18,525
Reviews
43
Average Words per Review
533
Rating
8.3
Compared 31% of the time.
Compared 25% of the time.
Compared 14% of the time.
Compared 6% of the time.
Compared 4% of the time.
Compared 16% of the time.
Compared 12% of the time.
Compared 9% of the time.
Compared 9% of the time.
Compared 8% of the time.
Microsoft SQL Server, MSSQL, MS SQL
Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0. Some key advantages include:
- Derby has a small footprint -- about 2.6 megabytes for the base engine and embedded JDBC driver.
- Derby is based on the Java, JDBC, and SQL standards.
- Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.
- Derby also supports the more familiar client/server mode with the Derby Network Client JDBC driver and Derby Network Server.
- Derby is easy to install, deploy, and use.
SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.
Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.
Learn more about Apache Derby
Learn more about SQL Server
Logitech, Splice Machine, CrowdStrike, Lever, Human Solutions
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Comms Service Provider31%
Computer Software Company21%
Retailer7%
Energy/Utilities Company5%
Financial Services Firm15%
Computer Software Company13%
Manufacturing Company10%
Comms Service Provider7%
Computer Software Company26%
Comms Service Provider20%
Financial Services Firm7%
Media Company6%
No Data Available
Small Business38%
Midsize Enterprise23%
Large Enterprise39%
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: March 2021.
475,291 professionals have used our research since 2012.
Apache Derby is ranked 23rd in Relational Databases while SQL Server is ranked 1st in Relational Databases with 51 reviews. Apache Derby is rated 0.0, while SQL Server is rated 8.4. On the other hand, the top reviewer of SQL Server writes "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". Apache Derby is most compared with MySQL, Oracle Java DB, Oracle Database, MariaDB and IBM Db2 Database, whereas SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, Teradata and MariaDB.
See our list of best Relational Databases vendors.
We monitor all Relational Databases 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.