BMC AMI DevX vs IDERA SQL Diagnostic Manager for SQL Server comparison

BMC and IDERA are both solutions in the Database Development and Management category. BMC is ranked #20 with an average rating of 7.7, while IDERA is ranked #12 with an average rating of 7.0. BMC holds a 1.3% mindshare in DDM, compared to IDERA’s 4.1% mindshare. Additionally, 90% of BMC users are willing to recommend the solution, compared to 92% of IDERA users who would recommend it.

BMC AMI DevX

Read 19 BMC AMI DevX reviews

4,088 Views
164 Comparison Views

90% willing to recommend

IDERA SQL Diagnostic Manage...

Read 9 IDERA SQL Diagnostic Manager for SQL Server reviews

938 Views
722 Comparison Views

92% willing to recommend

BMC AMI DevX

IDERA SQL Diagnostic Manage...

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Sep 11, 2025

IDERA SQL Diagnostic Manager and BMC AMI DevX compete in the database management space, targeting different operational needs. IDERA tends to have an upper hand in system health monitoring and alerting, while BMC excels in integration and automation features.

Features: IDERA SQL Diagnostic Manager offers real-time SQL Server diagnostics, predictive alerts for enhanced server health management, and customization of alerts allowing granular level issue tracking. BMC AMI DevX focuses on robust DevOps support by integrating with development tools, facilitating code management, deployment, and automating processes, appealing to development teams.

Room for Improvement: IDERA could improve in integration capabilities with broader development tools, enhancing automation to better serve DevOps environments, and expanding database support. BMC AMI DevX might consider simplifying the learning curve for new users, reducing the complexity in setup processes, and improving cost-effectiveness for teams not fully utilizing its extensive features.

Ease of Deployment and Customer Service: IDERA offers quick deployment with extensive support, making it favorable for rapid onboarding where database monitoring is a priority. BMC AMI DevX provides comprehensive deployment focused on seamless integration with development environments, reflecting its commitment to customer support in complex environments.

Pricing and ROI: IDERA SQL Diagnostic Manager typically presents lower upfront costs, targeting budget-conscious buyers seeking immediate performance improvements. BMC AMI DevX may justify higher costs through its broader suite of tools which can lead to greater long-term value, especially for businesses emphasizing development efficiencies and automation.

To learn more, read our detailed Database Development and Management Report (Updated: September 2025).

Buyer's Guide

Database Development and Management

September 2025

Download the complete report

Helped 867,676 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

BMC AMI DevX

Ranking in Database Development and Management

20th

Average Rating

8.0

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

Software Configuration Management (1st), Debugging (8th), Mainframe Application Development (1st), Test Data Management (7th), Mainframe Testing Tools (1st), Data Masking (8th)

IDERA SQL Diagnostic Manage...

Ranking in Database Development and Management

12th

Average Rating

8.0

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Event Monitoring (11th)

Mindshare comparison

As of September 2025, in the Database Development and Management category, the mindshare of BMC AMI DevX is 1.3%, up from 0.4% compared to the previous year. The mindshare of IDERA SQL Diagnostic Manager for SQL Server is 4.1%, up from 3.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Database Development and Management Market Share Distribution
Product	Market Share (%)
IDERA SQL Diagnostic Manager for SQL Server	4.1%
BMC AMI DevX	1.3%
Other	94.6%

Database Development and Management

Featured Reviews

Brian Westerman

Director of R&D at Syzygy Inc.

Helps to make mainframe data management process easier and saves manhours

We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its initial cost. We would need to pay around 60,000 dollars to have all three products together. We also encountered issues during version updates.

Read full review

reviewer2317098

Assistant at a tech services company with 1,001-5,000 employees

Offers effective monitoring of resources but lacks the ability to connect to an AWS instance and write custom queries.

We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes We've set up alerts to notify us when performance deviates from the baseline we've configured for each resource. So, whenever that happens, we get an alert and can investigate immediately. So,…

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Once we got the configurations and deployment rolled out, it was very stable. I haven't had any major issues with Eclipse or the Topaz Workbench plugins."

"It helps our staff work by speeding up their documentation process."

"I think the most valuable features are code management, code deployment, and code generation. The fact that those three features are included makes BMC Compuware ISPW a robust product. If one of those features was missing, it would be less robust and less interesting. But because it has those three features, it is a very good solution for code development and management."

"We had parallel development before, but the way ISPW implements it is better. It has more control and oversight of the process, whereas before, it was like the Wild West. Everybody could have their own package with their own version of the component in it... ISPW is constantly aware of it. It notifies when someone else is using or has a different version of that component."

"The most valuable feature of Topaz is Xpediter. It's more flexible than Xpediter through MVS."

"It does our CICS NEWCOPYs and our Db2 binds for us, whereas before, that was a manual process. It takes a lot of the workload off of the operations folks and off the DBAs."

"It's a modernized development portal and helps reduce the learning curve for younger people coming in to work on the platform,"

"I have worked with DB2's great features in the last five years. The IDAA feature transformed the vision of warehousing, business analytics, and big data at my bank. Besides the mainframe, I saw that this solution was evolutionary. It gives real-time information."

More BMC AMI DevX pros

"The best part of SQL DM is the ability to customize alerts and counters. This allows our team to find an issue then alert on the issue at a granular level."

"The most valuable features are disk space projections for planning, and also the Snapshotting ability, to look back in time, to see what was going on the server at a particular time. It's basically the output of an sp_who2."

"Monitors and alerts on our mission critical instances in real-time on a 24/7 basis."

"We're able to diagnose issues prior to their actually becoming issues. Without the alerting, we wouldn't have a clue as to what was going to happen. With the alerting, it gives us a heads-up that a specific threshold has been met, and we need to take specific action."

"SQL DM made troubleshooting much easier and allowed multiple people to look into an issue with confidence."

"Memory and CPU utilization features are good."

"The ability to go back and look at historical data is the most valuable feature."

Cons

"I'm waiting to see what 19.2 for Topaz looks like, but I have a problem with the JES Explorer right now. It limits you to a certain prefix for job names and there are some groups that have multiple prefixes that they'd like to see all at once in their job names, because of how they work in a group. And they can't see that in the JES Explorer."

"The solution could be improved by being better integrated with the open world. In the next release, I would like to have the ability to work in an open environment whilst remaining integrated with the legacy environment."

"One thing I would really like to see some improvement on is the promotion diagnostic messages. It invokes utilities "under the covers" to copy components, and it does not echo back any of the error messages from those utilities."

"It often doesn't play well with other plugins in the environment."

"The area for improvement is related to the testing tools that are available for unit testing or acceptance testing. I know they have some out there that we are not licensed for at this time, but it seems like some of the Eclipse tools that are used for other programming languages, they're all just built-in and they're a little more intuitive to the developers. Making those testing tools as intuitive as possible, and as integrated as possible into the workbench, would be really beneficial."

"It's a very complicated tool."

"I'm always looking for improvement in things like the documentation, to make things a little bit easier and simpler to understand, a place where people can go to troubleshoot issues."

"We plan to replace BMC Compuware File-AID due to its price. Two years back, we paid 11,000 dollars. However, the current price is 27,900 dollars. The price has increased to at least eight times its initial cost. We would need to pay around 60,000 dollars to have all three products together. We also encountered issues during version updates."

More BMC AMI DevX cons

"They can improve checking the status of the CPU, memory, and IO utilization from each task."

"One thing I'd like to see is the ability to view the execution plan and have the system automatically recommend potential query optimizations, especially at the query level."

"We don't find that it helps us with performance monitoring and diagnostics. We find that SentryOne does that better. Also, in terms of alerts, we had to customize them dramatically so that we didn't get alerted on every little thing."

"The initial setup gives too many user rights to the server, so you have to put a user that is part administrator's group - that's the preferred way - on each server, which is kind of a risk. You want to do least privilege and you're not doing that."

"I would absolutely love to create customized dashboards but, unfortunately, they don't provide me the information that I need to create the report. The report I need is the detail or the transaction detail that's happening on those Snapshots. I'd like to be able to go back through time and search for things. I don't have that functionality, which is very disappointing. That's pretty bad and frustrating because I could query it and find out so much information about what's hitting my environment and when, but instead, they want control over it and to not give me that information. So it's encrypted. I can't pull it out and that is really bothersome."

"I'm going to do an upgrade which may resolve my issues, but one area for improvement is its ability to handle the amount of data that we collect with it. We're likely one of the largest installations, with over 300 servers being collected with this product, and sometimes there are gaps. That would really be my only concern, in terms of how the data is collected and stored, for consistency."

"It would helpful if SQL DM could mark when changes are made within the program."

Pricing and Cost Advice

"I like the seat-based licensing much more than MSU-based licensing, and that the cost has been competitive."

"The only thing I would mention related to the licensing and/or the pricing, is that they have some visualization features in there that are licensed by concurrent users. We're starting to trip up on that. We're looking to probably increase the number of concurrent licenses that we have. But those types of licensing strategies, where they license by concurrent users or the number of seats is confusing for some people. They don't understand why it works sometimes and doesn't work other times."

"In general, Compuware tools are very competitive."

"In terms of pricing, there isn't an extra charge for the parts of it we use. It comes with the licenses we purchased for other products, so no complaints there. The licensing is built in with the other products that you purchase from Compuware."

"The price point is great."

"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."

"The pricing is reasonable, it's comparable with the competitors."

"We were upgraded to Premium Support without their actually asking us, when we were quoted. Then I asked for Standard Support and that they had to re-quote us that. But they don't do that by default. They upcharge you by default, which I didn't think was very nice, without even asking."

See which vendors are best for you

Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.

See recommendations

867,676 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

37%

Insurance Company

12%

Computer Software Company

Manufacturing Company

Financial Services Firm

10%

Comms Service Provider

Insurance Company

Computer Software Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	6
Large Enterprise	16

By reviewers
Company Size	Count
Small Business	3
Midsize Enterprise	5
Large Enterprise	4

Questions from the Community

What do you like most about Compuware File-AID?

The product has made our mainframe data management process easier. It has helped us save manhours. The tool's most valuable feature is the ability to edit tape files. Its ability to clone files is ...

See all answers

What needs improvement with Compuware File-AID?

See all answers

What is your primary use case for Compuware File-AID?

We use the solution clone test files.

See all answers

What do you like most about IDERA SQL Diagnostic Manager for SQL Server?

The ability to go back and look at historical data is the most valuable feature.

See all answers

What needs improvement with IDERA SQL Diagnostic Manager for SQL Server?

One thing I'd like to see is the ability to view the execution plan and have the system automatically recommend potential query optimizations, especially at the query level. In future releases, I w...

See all answers

What is your primary use case for IDERA SQL Diagnostic Manager for SQL Server?

We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes.

See all answers

Comparisons

Endevor vs BMC AMI DevX

Compared 33% of the time

IBM File Manager vs BMC AMI DevX

Compared 16% of the time

IBM Debug for z/OS vs BMC AMI DevX

Compared 10% of the time

InterTest vs BMC AMI DevX

Compared 10% of the time

IBM Developer for z/OS Enterprise Edition (IDzEE) vs BMC AMI DevX

Compared 6% of the time

More BMC AMI DevX Competitors

Redgate SQL Toolbelt Essentials vs IDERA SQL Diagnostic Manager for SQL Server

Compared 32% of the time

SolarWinds Database Performance Analyzer vs IDERA SQL Diagnostic Manager for SQL Server

Compared 24% of the time

SCOM vs IDERA SQL Diagnostic Manager for SQL Server

Compared 14% of the time

SQL Sentry vs IDERA SQL Diagnostic Manager for SQL Server

Compared 13% of the time

Spotlight vs IDERA SQL Diagnostic Manager for SQL Server

Compared 12% of the time

More IDERA SQL Diagnostic Manager for SQL Server Competitors

Product Reports

Buyer's Guide

Test Data Management

August 2025

Download BMC AMI DevX product report

Buyer's Guide

IDERA SQL Diagnostic Manager for SQL Server

September 2025

IDERA SQL Diagnostic Manager for SQL Server report

Download IDERA SQL Diagnostic Manager for SQL Server product report

Also Known As

File-AID, Data for Db2, Code Debug, Data Studio, Workbench for Eclipse, Code Pipeline

IDERA SQL DM, IDERA SQL Diagnostic Manager

Overview

BMC AMI DevX is a comprehensive solution enhancing code management and testing efficiency. It offers debugging capabilities within financial applications and integrates data management seamlessly, serving major banking sectors with reliable performance.

AMI DevX is tailored for banking industries, optimizing application debugging in COBOL and enhancing data handling in robust financial systems. It simplifies mainframe data management with real-time insights, improving efficiency through editing and cloning functionalities. The tool's integration with Compuware File-AID for IMS and DB2 ensures streamlined development processes. Challenges include a steep DB2 learning curve and initial setup complexities, with technical support inconsistencies and steep pricing impacting affordability. Despite this, its valuable features significantly support large banking operations.

What features make BMC AMI DevX valuable?

Line-by-Line Code Debugging: Allows precise identification and rectification of issues.
Variable Change & Line Skipping: Flexibility in testing without recompiling.
Database-Independent Testing: No need for loading databases during testing.
Real-Time Data Insights: Enhances decision-making with immediate information.
Data Warehousing & Analytics: Facilitates comprehensive data analysis.
Integration & Formatting: Streamlines development by simplifying data processes.

What benefits should users look for in reviews?

Improved Efficiency: Streamline data management and editing capabilities.
Robust Debugging: Effective in both online and batch COBOL program debugging.
Enhanced Financial Application Support: Superior handling in grants and loans applications.
Comprehensive Testing: Enables creation of clone test files for thorough testing.

In large banking sectors, BMC AMI DevX is integral for grants and loans-related applications. Its robust nature supports financial systems, offering debugging for COBOL, updating data in Compuware File-AID for IMS, and integrating DB2. Users implement this for exceptional data management and application reliability.

BMC

SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy SQL Server and Windows.

IDERA

Sample Customers

Helvetia, The IMT Group, Hapag-Lloyd, Royal Bank of Canada, Chunghwa Telecom

Padnos, University of Notre Dame, D4, Infeon Technologies, Chevron, LC Waikiki, Sisters of Saint Francis Health Services, Seattle Cancer Care Alliance, CVE, Colorado State University, St. Charles, Chaucer PLC, 1-800-Flowers, Ancoris, Money Management, National Opinion Research Center, California Department of Health, Plexus; Aviva, Burlington Northern Santa Fe, CBS, Comcast, Google, Merck, Regions Financial, Schneider Electric, Tata Consultancy Services, Verizon Communications, Zurich Financial Services

Buyer's Guide

Database Development and Management

September 2025

Download Free Report

Find out what your peers are saying about Nutanix, Oracle, Quest Software and others in Database Development and Management. Updated: September 2025.

DOWNLOAD NOW

867,676 professionals have used our research since 2012.

See our list of best Database Development and Management vendors.

We monitor all Database Development and Management 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.