We performed a comparison between IDERA ER/Studio and SQL Sentry 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."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."
"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."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"It does the job."
"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."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"The reverse engineering is the most important feature."
"We use the solution to create data models which describe our company's data architecture"
"To be able to go back in history and find out what was happening at certain times is the most valuable feature of the product."
"This solution has identified blocking, deadlock, memory pressure, and high CPU consumption issues."
"This solution needs more precise documentation."
"We would always like to see Repository performance improve, checking in and checking out."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"The visual presentation is a little too colorful and seems that it is dumbed down."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"There could be some more metrics on the high availability to let us know when there are issues synchronizing between the hosts."
"If we can get details on wait types from system views, it will help identify a more detailed root cause."
IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews while SQL Sentry is ranked 8th in Database Development and Management with 2 reviews. IDERA ER/Studio is rated 8.4, while SQL Sentry is rated 9.0. 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 SQL Sentry writes "Lets you know when your jobs are taking longer than average and allows you to go back in history and find out what was happening at certain times". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest, whereas SQL Sentry is most compared with SolarWinds Database Performance Analyzer, IDERA SQL Diagnostic Manager for SQL Server, Quest Spotlight, Redgate SQL Toolbelt and Quest Foglight for Databases.
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.