What users are saying about
82 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
440 Ratings
82 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

SQL Developer

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
440 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100

Likelihood to Recommend

DB2

DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.
Anonymous | TrustRadius Reviewer

SQL Developer

Oracle SQL Developer is well-suited for all companies that are using Oracle SQL Databases. First and foremost, it is absolutely free, and there are many free in-depth tutorials and documentation online to answer all of your questions. No matter the amount of experience, I am sure all database administrators will be able to work much more productively with their organization's databases through this IDE.
Anonymous | TrustRadius Reviewer

Pros

DB2

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
J.R. Bullington | TrustRadius Reviewer

SQL Developer

  • Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
  • Easily preview data columns on an Oracle table or view and the metadata on those columns.
  • SQL Editor is color-coded so that you can tell easily what are keywords.
  • You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.
Anonymous | TrustRadius Reviewer

Cons

DB2

  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
Anonymous | TrustRadius Reviewer

SQL Developer

  • Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
  • Detailed analysis of models can be clunky for complex relational models.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

DB2

DB2 8.0
Based on 2 answers
Because it is required to support our business unit
Anonymous | TrustRadius Reviewer

SQL Developer

SQL Developer 8.0
Based on 1 answer
No answer on this topic is available.

Usability

DB2

DB2 5.0
Based on 1 answer
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
J.R. Bullington | TrustRadius Reviewer

SQL Developer

No score
No answers yet
No answers on this topic

Reliability and Availability

DB2

DB2 9.9
Based on 10 answers
DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.
Roberto Etcheverry | TrustRadius Reviewer

SQL Developer

No score
No answers yet
No answers on this topic

Performance

DB2

DB2 9.6
Based on 10 answers
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Anonymous | TrustRadius Reviewer

SQL Developer

No score
No answers yet
No answers on this topic

Alternatives Considered

DB2

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.
Anonymous | TrustRadius Reviewer

SQL Developer

Toad and SQL developer are often compared and we considered both at the beginning. Arguably, Toad outperforms SQL developer in terms of many functionalities. The biggest reason we encouraged our engineers to use SQL developer was cost. Although it is not enriched like Toad, it is still a very well functioning and supported product.
Anonymous | TrustRadius Reviewer

Scalability

DB2

DB2 8.6
Based on 10 answers
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.
Josh Rice, MBA, ACSP | TrustRadius Reviewer

SQL Developer

No score
No answers yet
No answers on this topic

Return on Investment

DB2

  • Positive - Very good performance as compared to other traditional DBs.
  • Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
  • Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.
Pradeep Bele | TrustRadius Reviewer

SQL Developer

  • SQL Developer is a free tool that comes with the licenses of Oracle Database, so it's quite inappropriate to talk about ROI of this software itself.
  • SQL Developer is not a "you get what you pay for" product. Using it can cut out an entire line from your budget, so there is no comparison in that regard. We now only buy a few licenses for other similar tools and only when the user can prove SQL Developer doesn't meet the need.
  • In some cases, new programmers come in that are not familiar with SQL Developer. People tend to like what is familiar, so there is some initial time spent learning the tool. But that is balanced out because it really is pretty intuitive.
Krishan Mohil | TrustRadius Reviewer

Pricing Details

DB2

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

SQL Developer

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison