We performed a comparison between IDERA ER/Studio, IDERA SQL Admin Toolset, and MIMIX [EOL] based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"We are able to document the data lineage and data flows of our data from one system to another."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"We use the solution to create data models which describe our company's data architecture"
"This product allows for much easier cross server monitoring and administration."
"SQL Server Configuration: This allows admins to compare and edit server configurations for one or more SQL servers saving a lot of time when managing large numbers of instances."
"The initial setup is straightforward. It's very easy to implement the solution. Deployment took about one hour. You only need one person for deployment and maintenance, so long as that person has a good background of administration and operation."
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The screens are a bit outdated. They could use a new look and feel."
"The only thing I had an issue with was licensing, and the support was very good."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"This solution needs more precise documentation."
"A set of T-SQL admin snippets might be useful, e.g., code to create users, databases, indexes, etc. It would definitely be welcomed in the bundle."
"The solution could use better dashboards for new users. They can look complicated until you get used to using the solution."
Earn 20 points
Earn 20 points