When comparing DataGrip vs dbForge Studio for Oracle, the Slant community recommends dbForge Studio for Oracle for most people. In the question“What are the best SQL Clients for Windows?” dbForge Studio for Oracle is ranked 1st while DataGrip is ranked 4th. The most important reason people chose dbForge Studio for Oracle is:
Has full IDE features for PL/SQL such as: - Automatic code completion - Code snippets - Quick information on schema objects - Document outline for navigation - Smart formatting of SQL code
Ranked in these QuestionsQuestion Ranking
Pro Supports multiple languages
DataGrip is not a language-specific IDE. It supports a wide variety of languages by default, such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Derby, H2, Sqlite, and many more.
You can also specify your own JDBC drivers to get support for additional platforms.
Pro Beautiful and customizable UI
DataGrip currently provides two theme options, light and dark. The UI is intuitive to navigate and provides powerful features such as a diagram view of table relationships.
Pro Refactoring support
You can refactor SQL code with DataGrip — it resolves all references automatically and when an object/variable is renamed, you can choose to update all references to it in your project.
Pro Helps you avoid mistakes
It can catch SQL bugs and suggest ways to resolve them. It will inform of unresolved objects and the use of keywords as identifiers.
Pro Version control support
DataGrip supports a wide variety of VCS tools out of the box so that you can edit, test, and commit changes without ever leaving the tool.
Pro Powerful data editor
A powerful table editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once.
Pro Excellent code completion
DataGrip's code completion is context-sensitive and schema-aware code completion. It will take into account tables structure, foreign keys, and even database objects created in your code.
Pro Much more powerful than its counterparts
DataGrip is a full-featured IDE for working with databases and SQL. It includes commonly found features in database clients, and offers IDE-specific features beyond that — version control, autocompletion, refactoring support, etc.
Pro IDE features
Has full IDE features for PL/SQL such as:
- Automatic code completion
- Code snippets
- Quick information on schema objects
- Document outline for navigation
- Smart formatting of SQL code
Pro Oracle PL/SQL Debugger
Pro You can execute stored programs step-by-step
Using the PL/SQL debugger you can execute queries step-by-step. Using breakpoints, evaluating and modifying variables or by analyzing the active stack of your PL/SQL program.
Pro Great overall functionality
dbForge Studio offers a very complete set of features.
Pro Has an easy to use object manager
Pro Manages different database versions
Pro Query profiler
You can find any issues that slow down your queries using the query profiler. Once you detect these issues you can change your SQL and optimize the queries.
Pro Great data manipulation features
Pro Very complete refactoring function
dbForge has a very complete refactoring function that leverages their dependency capability. Change a column name or attribute and it is reflected throughout the entire design.
Pro Query Builder
Pro Can deploy an entire project or only the required changes to the server
Pro Great dependency analysis and refactoring functions
dbForge has great dependency analysis and refactoring functions. Each object, whether table or view, has a child object that is the list of all other objects that reference the table or view in question. Indispensable for large database design.
Pro Schema Import/Export
Pro Oracle Database Management
Con Not user friendly
This is an annual subscription with tiered pricing that diminishes a small amount year over year. But there are other much cheaper or free alternatives. This is the premium priced product of the bunch.
Con Performance can be slow/sluggish when working with high-volume databases
As with all other IDEs, DataGrip is powerful and thus requires more resources than usual. It can use up to several GB's of memory when working with high-volume databases, and this has an impact on performance if your system is not equipped to handle it.