dbForge Studio (Edge) vs. Oracle SQL Developer

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
dbForge Studio (Edge)
Score 8.9 out of 10
N/A
dbForge Studio is provided by Devart and is a universal front-end client for database management, administration and development. Devart's GUI tool provides utilities to compare, synchronize, and back up databases (e.g. MySQL, Oracle, SQL Server, PostgreSQL, etc.) with scheduling, and includes the possibility to analyze and report MySQL tables data. For example, dbForge Studio for MySQL works with any MariaDB database servers, and supports all MariaDB objects types. This solution enables users…
$9.95
per month
SQL Developer
Score 7.6 out of 10
N/A
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.N/A
Pricing
dbForge Studio (Edge)Oracle SQL Developer
Editions & Modules
Standard (subcription)
$9.95
per month
Professional (subscription)
$19.95
per month
Enterprise (subscription)
$29.95
per month
Standard (subcription)
$99.95
per year
Professional (subscription)
$179.95
per year
Standard
$199.95
Enterprise (subscription)
$229.95
per year
Professional
$349.95
Enterprise
$449.95
No answers on this topic
Offerings
Pricing Offerings
dbForge Studio (Edge)SQL Developer
Free Trial
YesNo
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
dbForge Studio (Edge)Oracle SQL Developer
Top Pros
Top Cons
Features
dbForge Studio (Edge)Oracle SQL Developer
Database Development
Comparison of Database Development features of Product A and Product B
dbForge Studio (Edge)
8.0
1 Ratings
6% below category average
Oracle SQL Developer
-
Ratings
Database change management8.01 Ratings00 Ratings
Best Alternatives
dbForge Studio (Edge)Oracle SQL Developer
Small Businesses
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 9.3 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 9.3 out of 10
Enterprises
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 9.3 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
dbForge Studio (Edge)Oracle SQL Developer
Likelihood to Recommend
9.8
(15 ratings)
7.5
(72 ratings)
Likelihood to Renew
-
(0 ratings)
10.0
(4 ratings)
Usability
-
(0 ratings)
8.2
(2 ratings)
Support Rating
8.0
(1 ratings)
7.0
(2 ratings)
Implementation Rating
-
(0 ratings)
9.2
(2 ratings)
User Testimonials
dbForge Studio (Edge)Oracle SQL Developer
Likelihood to Recommend
Devart
This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.
Read full review
Oracle
Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
Read full review
Pros
Devart
  • Connection manager (we use it through ssh tunnels) works effortlessly.
  • Great sync tools for both database schemas and data.
  • Storing code snippets to be used when needed.
  • Nice code suggestions while typing queries.
  • Usually does very well with storing your session and opening all of your sql tabs when opening the apps next time.
  • Does very well when executing large sql files (without opening the files into the application that is).
  • Pretty good debugging help when a problem occurs in executing a query or a files with multiple queries.
Read full review
Oracle
  • Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
  • The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
  • DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
Read full review
Cons
Devart
  • 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
Read full review
Oracle
  • Inability to run multiple queries on the same database. You can only run one query on a given database.
  • Analytical models created from complex tables isn't accurate, and needs work.
  • Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.
Read full review
Likelihood to Renew
Devart
No answers on this topic
Oracle
We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.
Read full review
Usability
Devart
No answers on this topic
Oracle
At times, Oracle SQL Developer may experience freezing issues. However, despite this occasional inconvenience, the tool offers valuable features such as the ability to integrate plugins like utPLSQL, which greatly assists in debugging and testing our packages. Additionally, the usage of breakpoints and the flexibility to format text according to individual configurations enhance the debugging process.
Read full review
Support Rating
Devart
Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.
Read full review
Oracle
Large user community support
Read full review
Implementation Rating
Devart
No answers on this topic
Oracle
Just download and uncompress!
Read full review
Alternatives Considered
Devart
Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio
Read full review
Oracle
I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.
Read full review
Return on Investment
Devart
  • Saved a TON of time when looking at massive amounts of parent/child data by allowing us to just use the master-detail browser.
  • Very little training time needed for employees that are already used to using SQL Management Studio. This is a proper Windows UI application.
  • Very cost effective to purchase the standard edition for every employee that needs it, but the free edition does most of what they need too!
Read full review
Oracle
  • It gives 100% return on investment as it is free of cost.
  • No need to have multiple tools for each database
  • Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.
Read full review
ScreenShots

dbForge Studio (Edge) Screenshots

Screenshot of Code CompletionScreenshot of Schema CompareScreenshot of Database DiagramScreenshot of Data ExportScreenshot of Database design & developmentScreenshot of Visual query building