Oracle Tools

Achieve Enterprise-level Productivity with dbForge Studio for Oracle!

We are thrilled to inform our Oracle users that dbForge Studio for Oracle got a really massive update that took database development and presentation of the development results to a new level! By popular request of our users of the Professional edition of dbForge Studio for Oracle, we have developed the advanced features and implemented them in the Enterprise edition of brand new dbForge Studio for Oracle, v4.0. (more…)

New Look and Feel of Compare Bundle for Oracle

We are glad to announce the release of the updated dbForge Compare Bundle for Oracle. The tools of the Bundle, dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle,  have been improved in-and-out. Besides the great new visual style, the tools include a bunch of new features and options that will definitely make your data and schema diffs management more smooth and convenient. (more…)

Create Unique Generators with dbForge Data Generator 2.0!

We are glad to notify our users that a new version of the Devart Oracle data generation tool has been released – dbForge Data Generator for Oracle, v2.0. The new version allows creating and saving your personal data generators, generating data to tables already filled with data, run data generation in a single click and much more! (more…)

Keep Calm and Document Oracle Databases

We are thrilled to inform that our dbForge for Oracle product line has been expanded with a brand new tool for smart and easy documenting of Oracle databases, – dbForge Documenter for Oracle! (more…)

ODAC Integration With dbForge Studio for Oracle

Database application development is usually divided into two stages: database design and application writing. Oracle Data Access Components for Delphi (ODAC) allow implementation of work with Oracle server, and dbForge Studio for Oracle – database design and administration. Now, for convenient development, integration with dbForge Studio for Oracle is implemented in ODAC.

(more…)

Adapting Diagram File to Another Database

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file.

Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database Diagram file. Now, you want to avoid redesigning the database model from scratch and only reassign the existing database model to another MySQL server. (more…)

Devart is glad to release the new improved version of dbForge Studio for Oracle, v 3.1

We’ve analyzed user feedbacks received after the release of the completely redesigned dbForge Studio and defined prior points for further development of the product.

As a result, we’ve devoted the new release of dbForge Studio for Oracle to improve the possibilities for users who work with PL/SQL code and data. And in addition, we’ve improved the application performance and added support for the Win-x64 platform. (more…)

Comparing Diffs Between Two Oracle Database Schemas

When developing databases, we frequently need to check what changes were made to its schema, if any mistakes were made, and, if there are any, we should roll back to the working version saved in the source control system. To do this, it’s enough to compare schemas of version 1.1 and 1.2, and generate an UPDATE SCRIPT using any Database Diff tool, including our dbForge Schema Compare for Oracle.

So what functionality should be available in such tool?

Firstly, the tool should be easy-to-use and user-friendly. A user should not be obliged to learn a pile of topics in the tool documentation before using it. It should be enough to perform the following set of steps:
1) Select Source and Target
2) Select a schema or several schemas (if the tool provides such possibility) for comparison
3) Tune comparison process by checking the needed options (an optional step)
4) View comparison results
5) Tune script generation options (an optional step)
6) Generate an update script and/or execute it directly to the target database
Secondly, the tool should support comparison of all object types you might have in your schemas – otherwise, how the tool is supposed to look for differences in them? And, at last, the tool should be fast. This point is especially important for searching data differences when a comparison of several schemas is performed, or the size of the project itself is large.

Now let’s look at Oracle SQL Developer and its alternative — dbForge Schema Compare for Oracle. Both are offering schema comparison functionality.
(more…)

How To Configure Oracle Instant Client

This article is a step-by-step instruction for configuring Oracle Instant Client so that our tools for Oracle could work with it.

(more…)

Schema Compare for Oracle is here – Early Access Preview of the new product

Having successfully released our data comparison tool for Oracle we went further by starting the new one. dbForge Schema Compare for Oracle is targeted to help database developers perform sustainable change management process. The tool is designed to:

  • compare Oracle schemes
  • analyze changes between databases
  • generate schema comparison reports
  • synchronize databases immediately or save sync scripts for later use

In order to allow our users to make changes and improve product even before the first release, we decided to publish early access preview of the dbForge Schema Compare for Oracle.

Visit product page http://www.devart.com/dbforge/oracle/schemacompare/ download product and leave us a feedback.