dbForge Studio for Oracle Reviews

12 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-2 of 2)

Chris Oros | TrustRadius Reviewer
February 13, 2020

Quick Database Comparisons

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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
  • 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

Whenever a user or DBA wants to compare schematics between two environments, dbForge is extremely helpful. This is useful during version or framework upgrades, a database upgrade, patch implementations, service package implementations, or any time to environments would be different.

The time it would take to write and execute queries, and then compare is exponentially longer than it takes with dbForge, where this is done and you have an application that allows you to quickly identify incongruities.

Read Chris Oros's full review
Anonymous | TrustRadius Reviewer
January 23, 2019

Once you try it, there is no going back

Score 6 out of 10
Vetted Review
Verified User
Review Source
dbForge Studio for Oracle is used mostly by our DBAs for administrative tasks, writing queries, etc. It was much more stable than any of the other potential solutions that we tested. It also allows us to synchronize data and schema for test cases, or to merging customized environments back into our core product for additional customization. Our Human Resources department was also looking into using this to manage their data as well.
  • It allows for easy synchronization between Oracle databases and schemas.
  • Installation and configuration was a breeze, so it provided a quick return on investment.
  • It runs quite well on standard hardware.
  • There can be problems when attempting to run it over Linux.
  • There were some formatting issues when Windows 10 came out, but they were addressed.
  • The full version was a little bit more expensive than we were hoping.
It is a great tool for synchronizing databases and schemas, especially when you need to take customized software for a particular client and bring it back in-house for additional enhancement requests. It is well-suited for environments where the easy-to-use GUI can provide almost instantaneous results with little or no training. It it highly scalable and can be used in one department or enterprise-wide.
Read this authenticated review

dbForge Studio for Oracle Scorecard Summary

About dbForge Studio for Oracle

dbForge Studio for Oracle is an IDE which helps developers to increase PL/SQL coding speed. It provides Oracle database GUI management tools, allows users to synchronize Oracle data and automate schema change management process. dbForge Studio for Oracle is focused on enhancing productivity and simplifying Oracle database development and management tasks.

dbForge Studio for Oracle Features

Has featureOracle Database Connectivity
Has featureAdministration Tools
Has featureData Analysis
Has featureData Comparison
Has featureData Editor
Has featureDatabase Explorer
Has featureDebugger
Has featureExporting and Importing Data
Has featureDatabase Project helps users facilitate database development: create a database project either empty or with imported database objects, manage SQL scripts and query files in the project.
Has featureDatabase Change Management helps users to save modifications that may have been made, compare and synchronize Oracle database schemas, generate schema comparison reports.
Has featureObject Manager helps to create and edit objects using visual objects editors. * Integrated PL/SQL Debugger is a reliable tool that automates all time-consuming tasks connected with debugging and provides full code control.
Has featureQuery Profiler helps users to analyze query behavior. It provides the following features: integrated profiling, query optimization, query change history.
Has featureSchema Import/Export dbForge Studio for Oracle provides convenient Export/Import Utility wizards for working with the command line interface of Oracle export and import utilities.
Has featurePL/SQL coding assistant in addition to a code beautifier allows users to speed-up the process of writing SQL queries, standardize PL/SQL code.

dbForge Studio for Oracle Screenshots

dbForge Studio for Oracle Competitors

Toad for Oracle, Navicat for Oracle, SQL Maestro

Pricing

  • Has featureFree Trial Available?Yes
  • Has featureFree or Freemium Version Available?Yes
  • Does not have featurePremium Consulting/Integration Services Available?No
  • Entry-level set up fee?No
EditionPricing DetailsTerms
Standard Edition149.95
Professional Edition399.95

dbForge Studio for Oracle Support Options

 Free VersionPaid Version
Live Chat
Email
Forum/Community
FAQ/Knowledgebase
Social Media
Video Tutorials / Webinar

dbForge Studio for Oracle Technical Details

Deployment Types:On-premise
Operating Systems: Windows
Mobile Application:No
Supported Languages: English