Introducing G2.ai, the future of software buying.Try now
Compare Microsoft SQL Server and SmartConnect 
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.5% of reviews)
Mid-Market (60.0% of reviews)
Entry-Level Pricing
No pricing available
$350.00 Per Month
Microsoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL ServerSmartConnect
Star Rating
(36)4.8 out of 5
Market Segments
Mid-Market (60.0% of reviews)
Pros & Cons
Entry-Level Pricing
$350.00 Per Month
Browse all 4 pricing plansSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Microsoft SQL Server excels in its Query Language with a score of 9.2, making it a preferred choice for complex queries, while SmartConnect, although strong, scores slightly lower at 8.8. Reviewers mention that SQL Server's T-SQL capabilities provide robust options for data manipulation.
- Reviewers mention that SmartConnect shines in Ease of Setup with a score of 8.9 compared to SQL Server's 8.1. Users on G2 appreciate SmartConnect's user-friendly interface and quick deployment, which is particularly beneficial for mid-market companies.
- G2 users highlight the superior Quality of Support for SmartConnect, scoring 9.4, while SQL Server scores 8.3. Users report that SmartConnect's support team is responsive and helpful, which is crucial for businesses needing timely assistance.
- Users say that Microsoft SQL Server offers strong Data Replication capabilities with a score of 8.8, which is essential for enterprise-level data management. In contrast, SmartConnect's replication features are noted as less comprehensive, impacting its appeal for larger organizations.
- Reviewers mention that SmartConnect's Custom Connectors feature, scoring 9.0, allows for greater flexibility in integrating with various applications, while SQL Server's pre-built connectors score lower at 7.3, indicating a potential limitation for users needing extensive integration options.
- Users report that Microsoft SQL Server's Backup and Recovery features are robust, scoring 9.0, which is critical for enterprise users. In comparison, SmartConnect's backup options are perceived as less comprehensive, which may be a concern for users prioritizing data security and recovery.
Pricing
Entry-Level Pricing
Microsoft SQL Server
No pricing availableSmartConnect
Startup
$350.00
Per Month
Starter Level for Initial Bulk + Ongoing Integration
- Unlimited Integrations
- 2 Standard Connections
- Dual Use to SmartConnect.com and Smart Connect On-Premise
Free Trial
Microsoft SQL Server
No trial information availableSmartConnect
Free Trial is available
Ratings
Meets Requirements
9.0
1,849
8.9
30
Ease of Use
8.6
1,865
8.5
34
Ease of Setup
8.1
986
8.6
33
Ease of Admin
8.3
947
8.6
27
Quality of Support
8.3
1,643
9.3
30
Has the product been a good partner in doing business?
8.4
897
9.6
27
Product Direction (% positive)
8.4
1,820
9.6
32
Features by Category
Management
8.9
151
Not enough data
8.9
151
Not enough data
9.2
156
Not enough data
8.9
151
Not enough data
8.9
153
Not enough data
Maintenance
8.9
151
Not enough data
9.0
156
Not enough data
9.0
152
Not enough data
Security
8.9
150
Not enough data
9.1
152
Not enough data
Management
9.1
149
Not enough data
9.2
150
Not enough data
8.8
136
Not enough data
8.9
142
Not enough data
Support
8.6
145
Not enough data
9.0
149
Not enough data
8.7
144
Not enough data
8.4
148
Not enough data
Security
8.9
148
Not enough data
9.0
148
Not enough data
8.9
145
Not enough data
9.0
148
Not enough data
Performance
8.7
144
Not enough data
8.8
141
Not enough data
8.8
147
Not enough data
8.7
145
Not enough data
8.8
146
Not enough data
Database Features
8.9
1284
Not enough data
9.0
1289
Not enough data
8.9
1296
Not enough data
8.7
1263
Not enough data
8.8
1265
Not enough data
8.8
1271
Not enough data
9.1
1291
Not enough data
Development
Not enough data
8.5
8
Not enough data
7.5
6
Not enough data
8.7
5
Not enough data
8.6
6
Not enough data
8.3
6
Not enough data
8.7
5
Not enough data
8.3
5
Management
Not enough data
8.1
6
Not enough data
8.1
6
Not enough data
9.4
6
Not enough data
8.0
5
Not enough data
8.0
5
Security
Not enough data
9.0
5
Not enough data
9.0
5
Not enough data
9.0
5
Integration Options
Not enough data
9.3
5
Not enough data
9.0
5
Not enough data
8.3
5
Not enough data
8.0
5
Deployment
Not enough data
9.0
5
Not enough data
8.7
5
Development
Not enough data
8.5
11
Not enough data
8.8
11
Management
Not enough data
7.3
10
Not enough data
8.3
10
Integration Options
Not enough data
9.2
11
Not enough data
9.2
11
Not enough data
8.5
9
Not enough data
7.0
9
Connectors
Not enough data
9.2
12
Not enough data
8.8
13
Security
Not enough data
8.8
12
Integration
Not enough data
9.4
12
Not enough data
9.2
12
Automation
Not enough data
8.6
12
Database
8.5
56
Not enough data
8.8
57
Not enough data
8.4
54
Not enough data
Integrations
7.8
45
Not enough data
8.2
45
Not enough data
Platform
8.2
50
Not enough data
8.5
53
Not enough data
8.2
45
Not enough data
Processing
8.5
52
Not enough data
8.5
55
Not enough data
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 SmartConnect are categorized as On-Premise Data Integration
Unique Categories
Microsoft SQL Server is categorized as Relational Databases, Database Management Systems (DBMS), and Big Data Processing and Distribution
Reviews
Reviewers' Company Size
Microsoft SQL Server
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
SmartConnect
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.2%
Higher Education
2.9%
Other
49.6%
Consulting
14.3%
Information Technology and Services
11.4%
Manufacturing
5.7%
Telecommunications
5.7%
Hospitality
5.7%
Other
57.1%
Alternatives
Discussions
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 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
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
SmartConnect has no discussions with answers
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.
