IDERA ER/Studio Review

We're able to control check-in's of our onshore and offshore developers while maintaining schema views, but the current version does not properly generate SQL Server-computed columns.

What is most valuable?

  • Reverse engineering physical database
  • Compare and Merge utility

How has it helped my organization?

We have offshore developers/DBA who actively request/implement DDL changes vs. a development database. The changes are reversed-engineered into both logical and physical schemas with generated DDL for source control check-in/check-out and other environment synchronization. With both onshore and offshore development teams working 18x5 days, it is an easy way to control check-in's while also maintaining schema views.

What needs improvement?

This version does not properly generate SQL Server computed columns; future versions do this.

For how long have I used the solution?

I've used it for eight months.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

It was pretty good once the licensing phase was completed.

Technical Support:

It's good.

Which solution did I use previously and why did I switch?

I am relatively new to this company, but in previous companies I used CA ErWin and SAP PowerDesigner. ErWin is very easy to use, as is PowerDesigner. The latter also provides a free developer viewer tool. At this point, all three products seem pretty equal: I would look at the conceptual model (business process rule) capture/conversion/maintenance with dynamic links to logical/physical ER with data dictionary/MDM capabilities to possibly separate them.

What was our ROI?

Since we are just reverse-engineering existing databases, and not using it for primary design/deployment/communication, relatively low.

What's my experience with pricing, setup cost, and licensing?

Review the total number of architects/DBAs who need full access and developers who need to view the model/data dictionary to determine number/types, and whether a stand-alone vs. repository version is needed.

Which version of this solution are you currently using?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More IDERA ER/Studio reviews from users
...who work at a Government
...who compared it with erwin Data Modeler (DM)
Find out what your peers are saying about IDERA, erwin, Inc., SAP and others in Architecture Management. Updated: February 2021.
464,757 professionals have used our research since 2012.
Add a Comment