We performed a comparison between IDERA ER/Studio and Toad Data Modeler based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"We are able to document the data lineage and data flows of our data from one system to another."
"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"The reverse engineering is the most important feature."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"I found all features valuable and necessary in Toad Data Modeler, particularly how good the solution is for modeling, database schema generation, and database re-engineering. I also found Toad Data Modeler straightforward to use."
"It is not feasible for small businesses. It is not used in a small company."
"Auto-complete is the best feature of the solution."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"We would always like to see Repository performance improve, checking in and checking out."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"What needs the most improvement are semantic lineage and usability."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"Many users don't know how to add licensing to Toad, or where it is shown, so they could make that easier."
"The product should provide better debugging features."
"What could be improved in Toad Data Modeler is stability and the complex setup."
"It is not feasible for small businesses. It is not used in a small company."
IDERA ER/Studio is ranked 14th in Database Development and Management with 34 reviews while Toad Data Modeler is ranked 11th in Database Development and Management with 18 reviews. IDERA ER/Studio is rated 8.4, while Toad Data Modeler is rated 8.4. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of Toad Data Modeler writes "Along with an initial setup that is straightforward, the solution offers excellent support to users". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, erwin Evolve by Quest and LeanIX, whereas Toad Data Modeler is most compared with Oracle SQL Developer, Aqua Data Studio, Toad Edge, Toad for Oracle and Redgate SQL Toolbelt. See our IDERA ER/Studio vs. Toad Data Modeler report.
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.