We performed a comparison between CockroachDB 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 most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."
"I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance."
"The best feature of CockroachDB is the ability to keep the nodes in different locations."
"The availability and the easy to use feature is the most valuable. The documentation is also good."
"The subset of SQL that my client is using is completely supported."
"The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds."
"CockroachDB is highly reliable."
"The initial setup and deployment are simple."
"The performance is reliable."
"The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus."
"The solution seems to be pretty flexible."
"The interface for building the queries or writing the store procedures is good."
"Easy to implement and user-friendly relational database management system. This product is stable and scalable."
"The security and vulnerability management are well-managed through the vendor."
"I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it. You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers."
"I like that the new version has a memory-optimized table to improve the performance."
"The initial setup and pricing could be improved."
"The product must improve its disaster recovery features."
"I find the serverless offer a bit confusing."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling."
"The platform could be more extensible."
"CockroachDB needs to improve store processes."
"We are looking for more features to support distributed high availability and geo-partitioning."
"The solution is rather expensive."
"We have had problems implementing a data warehouse using SQL Server."
"The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster."
"While using it, we really didn't experience any pain points."
"Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster."
"I would like to have the ability to restore backups in the next release."
"The solution could be better integrated with the SQL Server Studio tool."
"I would like to see more integration with other products and it needs to be more secure."
CockroachDB is ranked 9th in Relational Databases Tools with 10 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. CockroachDB is rated 8.0, while SQL Server is rated 8.4. The top reviewer of CockroachDB writes "Open source with extensive documentation and a University for training". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". CockroachDB is most compared with Oracle Database, MySQL, Citus Data, Amazon Aurora and MariaDB, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. See our CockroachDB 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.