FoundationDB vs Microsoft SQL Server: What are the differences?
What is FoundationDB? Multi-model database with particularly strong fault tolerance, performance, and operational ease. FoundationDB is a NoSQL database with a shared nothing architecture. Designed around a "core" ordered key-value database, additional features and data models are supplied in layers. The key-value database, as well as all layers, supports full, cross-key and cross-server ACID transactions.
What is Microsoft SQL Server? A relational database management system developed by Microsoft. Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
FoundationDB and Microsoft SQL Server can be categorized as "Databases" tools.
"ACID transactions" is the top reason why over 2 developers like FoundationDB, while over 134 developers mention "Reliable and easy to use" as the leading cause for choosing Microsoft SQL Server.
What is FoundationDB?
What is Microsoft SQL Server?
Need advice about which tool to choose?Ask the StackShare community!
Sign up to add, upvote and see more prosMake informed product decisions
What are the cons of using FoundationDB?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with FoundationDB?
Sign up to get full access to all the tool integrationsMake informed product decisions
We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.
Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.
Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.
Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.