Quick Database Comparisons
Overall Satisfaction with dbForge Studio for MySQL
As part of an Oracle Utilities Suite upgrade implementation, dbForge Studio is being used to compare schemas between our current production environments and test upgraded environments. This tool has been essential in identifying DDL, index, partitioning, and PK and constraint errors. Because of our ability to quickly compare schema details between environments, we are able to quickly respond to Oracle SRs to ask about discrepancies we see between our base version installs and their product documentation. Identification of missing columns, columns with incorrect data types and character lengths, and missing tables have been key to keeping the infrastructure and data conversion side of our project on track.
Pros
- Quick, high-level comparison of thousands of tables and their details
- Intuitive identification of findings, such as discrepancies, inconsistencies, things that are equal, and source/target environment changes
Cons
- The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
- The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel
- Time saved is hard to measure, but perhaps weeks of cumulative analysis has been saved by having the application able to quickly compare schematics and data.
- Removing estimations and assumptions around deployed environments is also hard to measure. For example, instead of deploying a new patch, and trusting that high-level queries based on previous exercises will catch discrepancies, dbForge is able to examine all tables, views, indexes, jave components, triggers, and really any other common database object.
Although we had to pay licensing fees to use dbForge, one of the main reasons we chose dbForge is compliance-related: we did not want to use freeware to analyze our database, since we are a utility company that has personally identifiable information in our databases.
Additionally, dbForge had additional features that DBeaver did not, and a smoother application interface for non-DBA expert users to navigate.
Do you think dbForge Studio (Edge) delivers good value for the price?
Yes
Are you happy with dbForge Studio (Edge)'s feature set?
Yes
Did dbForge Studio (Edge) live up to sales and marketing promises?
Yes
Did implementation of dbForge Studio (Edge) go as expected?
Yes
Would you buy dbForge Studio (Edge) again?
Yes
Comments
Please log in to join the conversation