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 initial setup and deployment are simple."
"The best feature of CockroachDB is the ability to keep the nodes in different locations."
"The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds."
"The subset of SQL that my client is using is completely supported."
"CockroachDB is highly reliable."
"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 availability and the easy to use feature is the most valuable. The documentation is also good."
"The product has valuable security features."
"SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
"It's a flexible solution."
"I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server."
"Very stable relational database management system that offers ease of management, querying, and scaling. It has well-designed databases."
"The security and vulnerability management are well-managed through the vendor."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"Many developers like SQL Server."
"The columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
"I find the serverless offer a bit confusing."
"The product must improve its disaster recovery features."
"We are looking for more features to support distributed high availability and geo-partitioning."
"The platform could be more extensible."
"CockroachDB needs to improve store processes."
"The initial setup and pricing could be improved."
"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."
"SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."
"Other than Synapse and the other version of SQL Server, they face some problems while processing the data."
"They could improve the solution by allowing more portability between on-premise and the cloud."
"SQL Server backups could be better."
"They could improve by adding the SQL format."
"The solution is lacking a compound index for comparing values."
"I would like to see the performance improved. Migrating should be easier and the scalability needs improvement."
"Support could be improved."
CockroachDB is ranked 9th in Relational Databases Tools with 10 reviews while SQL Server is ranked 1st in Relational Databases Tools with 244 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 "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". 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, IBM Db2 Database and LocalDB. 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.