About dbForge Studio for Oracle

dbForge Studio for Oracle represents an authoritative integrated development environment (IDE) aimed at Oracle SQL developers. The database solution increases PL/SQL coding speed, synchronizes data between different Oracle servers and automates schema change management process during development. It is equipped with a GUI and versatile data editing tools, which facilitate managing both internal and external data.

Key features of the studio include a PL/SQL coding assistant that helps standardize PL/SQL codes and speeds-up the SQL queries writing process. The Database project tool facilitates website development by managing SQL scripts and query files in projects and deploying either through an entire project or only when changes to the server are required.&nb...


Read More

Supported Operating System(s):

Web browser (OS agnostic)

31 Reviews of dbForge Studio for Oracle

Average User Ratings

Overall

4.55 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(19)

19

4 stars

(10)

10

3 stars

(2)

2

2 stars

(0)

0

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 of 31 results

April 2020

Dinand from Sommite Information Systems

Verified Reviewer

Company Size: 2-10 employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

April 2020

Can't do without it

I'm using dbForge on a daily basis and to be frank, I can't do my job without it. When I'm on a server without it, I install at least the express edition because the way dbForge supports writing queries is unmatched.

Pros

It's a one stop tool for my database tasks

Cons

Sometimes it crashes when I accidentally press F10

Reasons for Choosing dbForge Studio for Oracle

dbForge is completer, more robust and more affordable. But above all, dbForge is more intuitive

July 2020

Scott from SunPath

Verified Reviewer

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Functionality

5.0

July 2020

Great SSMS replacement for MySQL newbies

So, for the record I'm an MSSQL guy from way back, and SSMS is my friend. I've been using it forever, and I think it's perhaps one of the best free pieces of software on the planet given what you can do with it. I like MSSQL/SSMS so much, and I'm so stubborn, that I stupidly connect to MSSQL when I am doing PHP pages. I took on a new client recently, and they are a MySQL shop, so I had to find a tool where the learning curve wouldn't waste a lot of my time. I have used the MSSQL version of dbForge Studio in the past, so when I realized they offered a MySQL version, I decided to give it a try. For me, dbForge Studio for MySQL is easily the closest in terms of look and feel to SSMS. I was able to install, connect to the sandbox they gave me, and dive right in. I was a little embarrassed about my lack of MySQL skills, so in about 30 seconds dbForge Studio was able to copy my sandbox DB over to a local MySQL server I set up so that I could play around with it and learn the nuances of MySQL over MSSQL. I ended up liking MySQL/dbForge Studio so much that I'm going to use MySQL as my go-to database technology on my projects going forward. I love this software and it offers a great value over its competitors and a shortened learning curve for those of use who use SSMS.

Pros

I love being able to completely copy a database from one server to another with a few clicks, which makes it super quick to keep my dev environment in sync with the live database. The code completion feature is so much quicker than SSMS, I love that you can set the delay, and it saves me a lot of typing in addition to keeping the case consistent within my SQL. The Visual Studio Blue makes it feel like I'm working with my old friend SSMS. The ability to mark different databases with shapes and colors is a thoughtful feature and reduces the chances of accidentally making a change in live instead of dev. The data generation feature is nice as well, as you can generate a lot of test data quickly. Also, one of the best features is the automated code formatting command (CTRL-K, D), which takes my sloppy, ill-formated SQL and turns it into beautifully formatted SQL. You can also easily output data to all kinds of formats including Excel, Sheets, csv, xml, etc., and save templates so that you can quickly generate the same reports.

Cons

The "Edit View" feature is a little clunky--you cannot edit SQL directly in the SQL tab, and when you try to do it in the Query Text tab, it constantly throws errors as you type. Sometimes you just need to do a quick edit to a view and it's a bit frustrating to deal with. I found myself opening up a new SQL window, copying my code, pasting into the new tab, modifying and copying back to the Query Text tab. There has to be an easier way.

Reasons for Choosing dbForge Studio for Oracle

dbForge Studio for MySQL is the closest to SQL Server Management Studio in terms of look, feel, and functionality. The other options were awkward and unintuitive for me to use.

April 2020

Chuck from Visible Technology Solutions

Company Size: 2-10 employees

Industry: Computer Software

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

1.0

Value for money

3.0

Customer support

1.0

Functionality

3.0

April 2020

We tried, it failed.

It was ok, but settings and config were not intuitive and had to contact support several times and they were not very helpful.

Pros

it has syncing and backup built in and it looked to be a better product.

Cons

it only ran on windows, alot of our devs use macOS.

Reasons for Choosing dbForge Studio for Oracle

I ended up going back to navicat.

June 2020

Jon from Beck Business Solutions

Company Size: 1 employee

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Functionality

5.0

June 2020

One of the few tools I can't do without!

I love it. I've used everything from SQuirreL SQL Client (not bad, open source java) to SSMS to TOAD and this is far and away the best product I've used. It's not even close.

Pros

dbForge Studio is essential for my team as it saves time and money for all of our developers no matter how much experience they have with SQL, Database maintenance and development (DDL), function & view creation/modification, etc. For my novice developers, dbForge has great tools to allow the developers to visually create a query using an intuitive UI. Once they create the query, they can examine the SQL dbForge creates to better understand how to write SQL using industry Best Practices. For experts, dbForge saves time (and typos) by giving us the ability to type a few characters instead of fully typing out the entire fiend name (for example typing 'usqd' instead of UserSurveyQueryData). It also has great tools for exporting so I can write and reuse an export query to dump data to pretty much any format (usually Excel 2007+) with consistent formatting. I also perform complex options like comparing the development and test databases to see not only structural differences (DDL) but even data differences upon demand. Once I've gone through and set the rules for SQL formatting, I can share them with the team and all of our SQL is consistently named and formatted.

Cons

We are restricted to installing on one machine. All of my developers use more than one computer. I myself have three. It's just the nature of the business and it's a real hassle not to be able to install on as many machines as I, as a single developer, use daily.

Reasons for Choosing dbForge Studio for Oracle

Functionality. This product saves me time both in creating/updating DDL & functions and in catching typos/errors before they make it into testing.

April 2020

Jhonathan from Vórtx

Verified Reviewer

Company Size: 51-200 employees

Industry: Financial Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

April 2020

It is a necessary tool for professionals

Pros

Intellisense is fantastic. You considerably reduce the amount of words typed

Cons

For large and complex queries, hardware consumption is something that needs to be improved.

Reasons for Choosing dbForge Studio for Oracle

I believe it is a product that delivers value even if it costs less.