Introducing G2.ai, the future of software buying.Try now

Compare IBM Informix and Microsoft SQL Server

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
IBM Informix
IBM Informix
Star Rating
(110)4.5 out of 5
Market Segments
Enterprise (44.0% of reviews)
Information
Entry-Level Pricing
See IBM website or contact IBM PVU, VPC,User licensing
Browse all 5 pricing plans
Microsoft SQL Server
Microsoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.6% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL Server
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Microsoft SQL Server excels in Disaster Recovery with a score of 9.7, highlighting its robust features for Scheduled Backups and On-Demand Restoration. In contrast, IBM Informix, while still strong, has a lower score of 9.2 in this area, indicating it may not be as comprehensive in recovery options.
  • Reviewers mention that IBM Informix shines in Data Replication, scoring 9.8 compared to Microsoft SQL Server's 8.8. Users appreciate Informix's seamless Data Replication capabilities, which are crucial for maintaining data consistency across distributed systems.
  • G2 users highlight the superior Query Optimizer in IBM Informix, which received a score of 9.8, while Microsoft SQL Server scored 8.8. Reviewers say that Informix's optimizer leads to better performance in complex queries, making it a preferred choice for data-intensive applications.
  • Users on G2 report that Microsoft SQL Server has a more user-friendly Ease of Setup with a score of 8.1, compared to Informix's 8.9. However, they mention that Informix's setup process is still relatively straightforward, making it accessible for users with varying levels of expertise.
  • Reviewers mention that Microsoft SQL Server's Quality of Support is rated at 8.3, which is slightly lower than IBM Informix's 8.5. Users appreciate the responsiveness and helpfulness of Informix's support team, which can be a deciding factor for businesses needing reliable assistance.
  • Users say that both products perform well in Data Schema management, with Microsoft SQL Server scoring 9.1 and IBM Informix at 9.4. However, Informix users report that its schema management features are more intuitive, allowing for easier modifications and updates.
Pricing
Entry-Level Pricing
IBM Informix
Informix Enterprise Edition / Informix Advanced Enterprise Edition
See IBM website or contact IBM
PVU, VPC,User licensing
Browse all 5 pricing plans
Microsoft SQL Server
No pricing available
Free Trial
IBM Informix
Free Trial is available
Microsoft SQL Server
No trial information available
Ratings
Meets Requirements
9.2
78
9.0
1,847
Ease of Use
9.1
78
8.6
1,863
Ease of Setup
8.9
56
8.1
984
Ease of Admin
9.3
56
8.3
945
Quality of Support
8.5
75
8.3
1,641
Has the product been a good partner in doing business?
7.8
56
8.4
895
Product Direction (% positive)
5.9
77
8.4
1,818
Features by Category
8.7
6
Not enough data
Management
8.6
6
Not enough data
8.7
5
Not enough data
8.7
5
Not enough data
8.7
5
Not enough data
Solution Provision
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
Not enough data
9.0
163
Management
Not enough data
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
Maintenance
Not enough data
8.9
150
Not enough data
9.0
155
Not enough data
9.0
151
Security
Not enough data
8.9
149
Not enough data
9.1
151
8.9
80
8.9
1,434
Management
9.0
10
9.1
147
9.0
10
9.2
148
8.9
9
8.8
134
9.3
10
8.9
140
Support
8.0
9
8.6
143
8.7
10
9.1
147
8.7
10
8.7
142
8.7
10
8.5
146
Security
8.5
10
8.9
146
9.0
10
9.1
146
8.3
10
8.9
143
8.7
10
9.0
146
Performance
8.7
9
8.8
142
8.5
9
8.9
139
8.3
10
8.8
145
9.1
9
8.7
143
9.3
9
8.9
144
Database Features
9.1
65
8.9
1282
9.5
66
9.0
1287
9.3
65
8.9
1294
9.2
64
8.7
1261
8.9
61
8.8
1263
9.1
64
8.8
1269
9.0
65
9.1
1289
Not enough data
Not enough 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
Not enough data
Not enough data
Reporting
Not enough data
Not enough data
Not enough data
Not enough data
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
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
Not enough data
8.4
57
Database
Not enough data
8.6
55
Not enough data
8.8
56
Not enough data
8.4
53
Integrations
Not enough data
7.8
44
Not enough data
8.3
44
Platform
Not enough data
8.3
49
Not enough data
8.6
52
Not enough data
8.3
44
Processing
Not enough data
8.6
51
Not enough data
8.5
54
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
Categories
Categories
Shared Categories
IBM Informix
IBM Informix
Microsoft SQL Server
Microsoft SQL Server
IBM Informix and Microsoft SQL Server are categorized as Relational Databases
Unique Categories
IBM Informix
IBM Informix is categorized as Data Replication
Reviews
Reviewers' Company Size
IBM Informix
IBM Informix
Small-Business(50 or fewer emp.)
23.1%
Mid-Market(51-1000 emp.)
33.0%
Enterprise(> 1000 emp.)
44.0%
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.6%
Reviewers' Industry
IBM Informix
IBM Informix
Information Technology and Services
16.5%
Computer Software
13.2%
Government Administration
9.9%
Retail
5.5%
Telecommunications
4.4%
Other
50.5%
Microsoft SQL Server
Microsoft SQL Server
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%
Alternatives
IBM Informix
IBM Informix Alternatives
MySQL
MySQL
Add MySQL
Oracle Database
Oracle Database
Add Oracle Database
PostgreSQL
PostgreSQL
Add PostgreSQL
Veeam Data Platform
Veeam Data Platform
Add Veeam Data Platform
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
IBM Informix
IBM Informix Discussions
Version 11.70 - Where should look if I am having problems with triggers via a stored procedure?
2 Comments
Eric V.
EV
Hi Rhonda, First of all you should clearly and at least look at upgrading to version 14.10 xC2, because 11.70 maintenance will stop by March 30th...Read more
Standard 4GL is still a great product, Why don't add new features?
1 Comment
Art S. K.
AK
IBM made a decision long ago to stop adding features to 4GL. You can get modern versions of 4GL from 4Js (Genero) and Querix (Lycia). Both are proper...Read more
How do I program 4GL and Create Mobile Apps.
1 Comment
Eric V.
EV
Hi Hwee, Form the feedback I received from several people, the best tools to develop mobile apps are the tools initially designed for that: they need to...Read more
Microsoft SQL Server
Microsoft SQL Server 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
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
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