Compare InterSystems IRIS and Microsoft SQL Server

At a Glance
InterSystems IRIS
InterSystems IRIS
Star Rating
(68)4.6 out of 5
Market Segments
Small-Business (50.0% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about InterSystems IRIS
Microsoft SQL Server
Microsoft SQL Server
Star Rating
(2,261)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL Server
AI Generated Summary
AI-generated. Powered by real user reviews.
  • G2 reviewers report that Microsoft SQL Server excels in user experience, particularly for beginners. Users appreciate its intuitive interface in SQL Server Management Studio (SSMS) and the straightforward implementation process, which includes clear setup steps and robust features like views and stored procedures.
  • Users say that InterSystems IRIS stands out for its comprehensive data platform capabilities. Reviewers highlight its pre-built components and simple data transformations GUI, making it accessible for users looking to implement solutions quickly and effectively.
  • According to verified reviews, Microsoft SQL Server is praised for its reliability and performance. Users specifically mention the "Always On" feature, which enhances database durability and application performance by effectively managing read and write operations.
  • Reviewers mention that InterSystems IRIS offers a unique programming experience with its M scripting language, allowing for flexibility and speed in development. This feature is particularly appreciated by users in the health IT sector, where rapid deployment is crucial.
  • G2 reviewers highlight that while Microsoft SQL Server has a higher overall satisfaction score, InterSystems IRIS receives commendations for its quality of support, with users noting that the support team is responsive and helpful in addressing issues.
  • Users report that Microsoft SQL Server integrates seamlessly with other Microsoft tools, enhancing its usability in environments already utilizing Microsoft products. This integration is a significant advantage for organizations looking to streamline their workflows.
Pricing
Entry-Level Pricing
InterSystems IRIS
No pricing available
Microsoft SQL Server
No pricing available
Free Trial
InterSystems IRIS
Free Trial is available
Microsoft SQL Server
No trial information available
Ratings
Meets Requirements
9.0
47
9.0
1,854
Ease of Use
8.0
47
8.6
1,870
Ease of Setup
8.0
27
8.1
992
Ease of Admin
7.9
19
8.3
950
Quality of Support
8.7
47
8.3
1,649
Has the product been a good partner in doing business?
8.8
17
8.4
900
Product Direction (% positive)
8.9
43
8.4
1,825
Features by Category
Not enough data
Not enough data
Data Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Analytics
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Generative AI
Not enough data
Not enough data
Not enough data
Not enough data
Agentic AI - Data Fabric
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
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
9.0
16
9.0
167
Management
8.8
14
8.9
153
9.2
13
8.8
153
9.0
14
9.2
158
8.7
13
8.9
153
9.2
13
8.9
156
Maintenance
9.2
13
8.9
154
9.3
12
9.0
159
8.7
13
9.0
154
Security
8.8
12
8.9
153
9.2
14
9.1
155
9.2
43
8.8
1,444
Management
9.4
18
9.0
149
8.9
17
9.2
151
9.2
14
8.8
137
9.6
17
8.8
142
Support
8.7
18
8.6
145
8.5
20
9.0
149
8.6
19
8.6
144
9.4
18
8.4
151
Security
9.3
15
8.8
148
9.5
18
9.0
148
9.5
18
8.8
145
9.1
18
9.0
149
Performance
8.9
17
8.7
144
9.2
16
8.8
141
9.1
17
8.7
147
9.6
16
8.6
145
9.4
16
8.8
146
Database Features
9.2
32
8.9
1287
9.2
32
9.0
1291
9.3
33
8.9
1299
9.1
33
8.7
1266
9.1
33
8.8
1267
8.9
31
8.8
1271
9.0
31
9.1
1291
9.2
8
Not enough data
Data Management
9.3
7
|
Verified
Not enough data
8.8
7
|
Verified
Not enough data
Availability
8.9
6
|
Verified
Not enough data
9.2
6
|
Verified
Not enough data
9.0
7
|
Verified
Not enough data
Performance
9.3
7
|
Verified
Not enough data
Security
9.2
6
|
Verified
Not enough data
8.3
7
|
Verified
Not enough data
Feature Not Available
Not enough data
9.2
6
|
Verified
Not enough data
Support
Feature Not Available
Not enough data
9.3
7
|
Verified
Not enough data
9.1
8
Not enough data
Data Management
9.5
7
Not enough data
9.0
7
Not enough data
8.3
7
Not enough data
8.9
6
Not enough data
Availability
9.3
5
Not enough data
9.0
5
Not enough data
9.4
6
Not enough data
Performance
9.7
5
Not enough data
Security
9.2
6
Not enough data
9.4
6
Not enough data
9.7
6
Not enough data
8.6
6
Not enough data
Support
9.0
5
Not enough data
9.0
7
Not enough data
8.6
6
Not enough data
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
Not enough data
8.4
57
Database
Not enough data
8.5
56
Not enough data
8.8
57
Not enough data
8.4
54
Integrations
Not enough data
7.8
45
Not enough data
8.2
45
Platform
Not enough data
8.2
50
Not enough data
8.5
53
Not enough data
8.2
45
Processing
Not enough data
8.5
52
Not enough data
8.5
55
Not enough data
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
9.0
42
Not enough data
Database Features
9.2
32
8.9
1287
9.2
32
9.0
1291
9.3
33
8.9
1299
9.1
33
8.7
1266
9.1
33
8.8
1267
8.9
31
8.8
1271
9.0
31
9.1
1291
Categories
Categories
Shared Categories
InterSystems IRIS
InterSystems IRIS
Microsoft SQL Server
Microsoft SQL Server
InterSystems IRIS and Microsoft SQL Server are categorized as Database Management Systems (DBMS) and Relational Databases
Unique Categories
Microsoft SQL Server
Microsoft SQL Server is categorized as Big Data Processing and Distribution and On-Premise Data Integration
Reviews
Reviewers' Company Size
InterSystems IRIS
InterSystems IRIS
Small-Business(50 or fewer emp.)
50.0%
Mid-Market(51-1000 emp.)
30.4%
Enterprise(> 1000 emp.)
19.6%
Microsoft SQL Server
Microsoft SQL Server
Small-Business(50 or fewer emp.)
18.4%
Mid-Market(51-1000 emp.)
36.1%
Enterprise(> 1000 emp.)
45.5%
Reviewers' Industry
InterSystems IRIS
InterSystems IRIS
Computer Software
28.6%
Hospital & Health Care
23.2%
Information Technology and Services
17.9%
Health, Wellness and Fitness
8.9%
Information Services
7.1%
Other
14.3%
Microsoft SQL Server
Microsoft SQL Server
Information Technology and Services
24.1%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Alternatives
InterSystems IRIS
InterSystems IRIS Alternatives
IBM Db2
IBM Db2
Add IBM Db2
PostgreSQL
PostgreSQL
Add PostgreSQL
Oracle Database
Oracle Database
Add Oracle Database
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Microsoft SQL Server
Microsoft SQL Server Alternatives
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Google Cloud SQL
Cloud SQL
Add Google Cloud SQL
Snowflake
Snowflake
Add Snowflake
Discussions
InterSystems IRIS
InterSystems IRIS Discussions
What is InterSystems IRIS used for?
1 Comment
GS
it's based on a great database, but today it`s a data plataform, were you can use as a middleware to your application, or use it as a database to your...Read more
Monty the Mongoose crying
InterSystems IRIS has no more discussions with answers
Microsoft SQL Server
Microsoft SQL Server Discussions
How could I make much easier the experience with the order of my database?
4 Comments
Afolabi F.
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