Introducing G2.ai, the future of software buying.Try now
Compare Microsoft SQL Server and OpenText Vertica 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
RaimaDB
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ER/Studio
Visit Website
At a Glance
Market Segments
Enterprise (45.6% of reviews)
Enterprise (44.6% of reviews)
Entry-Level Pricing
No pricing available
Free
Microsoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.6% of reviews)
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL ServerOpenText Vertica
Star Rating
(216)4.3 out of 5
Market Segments
Enterprise (44.6% of reviews)
Entry-Level Pricing
Free
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Microsoft SQL Server excels in Query Language with a score of 9.2, which reviewers mention makes it easier to write complex queries compared to OpenText Vertica's score of 8.8. This feature is particularly beneficial for users who require advanced data manipulation capabilities.
- Reviewers mention that Microsoft SQL Server's Data Migration capabilities score a perfect 9.0, indicating a seamless transition for users moving from other systems. In contrast, OpenText Vertica's migration features are not highlighted as strongly, which may pose challenges for users looking to switch.
- G2 users highlight the Backup and Recovery features of Microsoft SQL Server, also rated at 9.0, as a significant advantage, ensuring data safety and reliability. OpenText Vertica, while competent, scores slightly lower at 8.7, which may concern users prioritizing data protection.
- Users on G2 report that Microsoft SQL Server's Data Quality score of 8.6 is a strong point, with many reviewers appreciating its robust data validation features. OpenText Vertica, with a score of 8.4, is seen as slightly less effective in maintaining high data quality standards.
- Reviewers mention that Microsoft SQL Server's Data Replication capabilities, scoring 8.8, are highly regarded for their efficiency in maintaining data consistency across environments. OpenText Vertica's replication features, while functional, score the same but lack the same level of user satisfaction.
- Users say that Microsoft SQL Server's Performance Analysis features, rated at 8.9, provide valuable insights into system performance, which is crucial for optimizing workloads. OpenText Vertica, with a score of 8.6, offers similar features but does not receive the same level of acclaim from users.
Pricing
Entry-Level Pricing
Microsoft SQL Server
No pricing availableOpenText Vertica
Vertica Community Edition
Free
Free to use for up to 1TB and three nodes
- https://www.vertica.com/register/
Free Trial
Microsoft SQL Server
No trial information availableOpenText Vertica
Free Trial is available
Ratings
Meets Requirements
9.0
1,847
8.6
147
Ease of Use
8.6
1,863
8.5
148
Ease of Setup
8.1
984
8.1
84
Ease of Admin
8.3
945
8.3
89
Quality of Support
8.3
1,641
8.1
146
Has the product been a good partner in doing business?
8.4
895
8.3
87
Product Direction (% positive)
8.4
1,818
8.0
143
Features by Category
Data Management
Not enough data
8.4
71
|
Verified
Not enough data
8.5
72
|
Verified
Not enough data
8.6
73
Not enough data
8.5
66
|
Verified
Not enough data
7.9
43
|
Verified
Not enough data
8.4
49
|
Verified
Integration
Not enough data
7.7
43
|
Verified
Not enough data
8.4
65
|
Verified
Not enough data
8.2
50
|
Verified
Deployment
Not enough data
8.3
66
|
Verified
Not enough data
7.9
51
|
Verified
Performance
Not enough data
8.3
71
|
Verified
Security
Not enough data
8.3
66
|
Verified
Not enough data
8.5
67
|
Verified
Generative AI
Not enough data
8.3
8
Not enough data
7.9
8
Management
8.9
150
Not enough data
8.9
150
Not enough data
9.2
155
Not enough data
8.9
150
Not enough data
8.9
152
Not enough data
Maintenance
8.9
150
Not enough data
9.0
155
Not enough data
9.0
151
Not enough data
Security
8.9
149
Not enough data
9.1
151
Not enough data
Management
9.1
147
Not enough data
9.2
148
Not enough data
8.8
134
Not enough data
8.9
140
Not enough data
Support
8.6
143
Not enough data
9.1
147
Not enough data
8.7
142
Not enough data
8.5
146
Not enough data
Security
8.9
146
Not enough data
9.1
146
Not enough data
8.9
143
Not enough data
9.0
146
Not enough data
Performance
8.8
142
Not enough data
8.9
139
Not enough data
8.8
145
Not enough data
8.7
143
Not enough data
8.9
144
Not enough data
Database Features
8.9
1282
Not enough data
9.0
1287
Not enough data
8.9
1294
Not enough data
8.7
1261
Not enough data
8.8
1263
Not enough data
8.8
1269
Not enough data
9.1
1289
Not enough data
Storage
Not enough data
8.4
22
Not enough data
8.0
22
Availability
Not enough data
8.4
20
Not enough data
8.2
22
Not enough data
8.6
22
Performance
Not enough data
8.5
21
Security
Not enough data
8.4
22
Not enough data
8.6
22
Not enough data
8.2
19
Not enough data
8.2
21
Support
Not enough data
8.4
15
Not enough data
8.3
17
Database
8.6
55
8.6
48
8.8
56
8.7
47
8.4
53
8.6
47
Integrations
7.8
44
8.4
41
8.3
44
8.1
39
Platform
8.3
49
8.3
37
8.6
52
8.4
44
8.3
44
8.1
39
Processing
8.6
51
8.3
41
8.5
54
8.7
46
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Microsoft SQL Server and OpenText Vertica are categorized as Big Data Processing and Distribution
Unique Categories
Microsoft SQL Server is categorized as Relational Databases, Database Management Systems (DBMS), and On-Premise Data Integration
OpenText Vertica is categorized as Data Warehouse and Columnar Databases
Reviews
Reviewers' Company Size
Microsoft SQL Server
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
OpenText Vertica
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
24.2%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Computer Software
19.0%
Information Technology and Services
17.4%
Financial Services
6.7%
Telecommunications
5.6%
Retail
5.6%
Other
45.6%
Alternatives
Discussions
How could I make much easier the experience with the order of my database?
4 Comments
AF
You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data...Read more
What is the best way to save your queries?
4 Comments
CA
I recommend that you use the saved querys in plain text or .sql or txt format you can use the same sql server query creator or a notepad +++ tool, they are...Read more
How can I work on the same query if the connection is lost (timeout) and then I reconnect?
4 Comments
JE
When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute...Read more
Who uses Vertica and for what?
2 Comments
PR
A LOT of companies, from tiny startups to the biggest data companies.
7 of top 10 telecoms in world, including AT&T, plus companies like Anritsu that sell...Read more
Is it hard to learn to be a Vertica user? Admin?
2 Comments
PR
Also, check out the Vertica Academy: https://academy.vertica.com/ Free classes to learn how to admin Vertica, including certification. Read more
What’s the best use case for Vertica?
1 Comment
MG
For Finance: Fraud detection, Anti-money laundering, Risk management
For Government: Law enforcement, Counter terrorism, Traffic flow optimization
For...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
