Oracle Tools

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.

(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: (more…)

Loading Oracle LOB Data – Code Samples

Recently we were working over the release of the version 2.0 of  dbForge Data Compare for Oracle. One of the main features added to the new version was synchronization of the LOB data. When we developed the first release of the product we postponed this feature because of challenges of synchronizing LOB data. These challenges caused by nature of data stored in BLOB or CLOB columns. It’s large and simply does not fit into SQL script. But we’ve found the solution.

(more…)

Oracle DBMS_COMPARISON package overview

During replicating data in one or another way, it happens that synchronized objects may differ. This situation may take place in the following cases:

  • If changes made in one of copied databases were not captured
  • The changes were captured but not forwarded
  • The changed were forwarded but not applied due to some reasons (more…)

10 Ways to Synchronize Oracle Table Data

In the process of developing databases many developers and testers encounter a problem of synchronizing data between local and remote Oracle database. Changes made in a local database must be reflected in a remote database. It’s also necessary to check test results with the model database, to find non-synchronized tables that appeared after these tests, to have possibility to return the test database to its initial state when testing newly developed versions of databases intensively. Another problem may be to create CRUD operations quickly without making too much effort to find different objects and to write DML statements. Now let’s find out how one can synchronize data of Oracle databases.

(more…)