We performed a comparison between Citus Data 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."You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"Its distributed processing capabilities are a standout feature. It requires minimal changes to get up and running if you already have a system on PostgreSQL. Citus can run in its natural state."
"It's very straightforward to implement the solution. It took us two days to set up everything."
"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."
"The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query."
"Agent service is a good feature of SQL Server, where you can schedule certain tasks."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"The solution is configurable."
"The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete."
"You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
"The solution seems to be pretty flexible."
"There are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward."
"More features in monitoring and the reporting could make it better."
"Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues."
"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated."
"SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems."
"In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages."
"The upgrades are unstable."
"The maintenance and tasks should be improved so as to reduce database files."
"They could improve the solution by allowing more portability between on-premise and the cloud."
"Debugging from the debugger tool functionality should be enhanced."
"We pay a license fee, it could always be cheaper."
Citus Data is ranked 18th in Relational Databases Tools with 3 reviews while SQL Server is ranked 1st in Relational Databases Tools with 259 reviews. Citus Data is rated 8.0, while SQL Server is rated 8.4. The top reviewer of Citus Data writes "Efficiently handles high-traffic scenarios and compatible with PostgreSQL extensions, offering flexibility in database management". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Citus Data is most compared with YugabyteDB, CockroachDB, Amazon Aurora, MySQL and SingleStore, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. See our Citus Data 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.