When comparing HeidiSQL 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 HeidiSQL is ranked 3rd. 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
Licensed under GNU GPL.
Pro Great UI and ease of use
HeidiSQL has a comprehensive and intuitive interface.
Pro Data synchronization
HeidiSQL can compare and synchronize your data and structure between local and remote databases.
Alongside the possibility of downloading the installer and sourcecode, a portable version of the software is available.
Pro SSH tunnel
HeidiSQL allows connecting to your MySQL database via SSH tunnel.
Pro Works fine with Wine under Linux
Pro Syntax completion
Pro Great user management
The user manager of HeidiSQL can easily set privileges on a per-database level or give access to only certain commands.
Pro Connect to servers via command line
You can use command line parameters to automate connections.
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 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 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 Can deploy an entire project or only the required changes to the server
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 Schema Import/Export
Pro Oracle database management
Pro Support for JSON data
Pro Support for Google Sheets
Pro Documenter feature for documenting and presentation of the Oracle schemas.
Pro Data generator feature
Con Can be buggy
HeidiSQL is known to have some bugs that results in crashes.
Con No session backup
You cannot recover your session after close or even worse crash.
Con Works under Linux only with Wine
It works quite well under Wine with Linux, but you must always take notice if the last version of HeidiSQL has been tested, for it may not run at all. There are some bugs in the Wine version that can be annoying and you have to kill the program and restart it. A native Linux version would be great.
Con Intellisense is not intelligent
No intellisense for columns unless table name is aliased.