X

Best Practices from Oracle Development's A‑Team

Reverse Engineer DB objects from ADF-BC

Introduction

For a use case where you develop an application using ADF Fusion stack. When you need to plan backup and restore scenario for your application, you must consider both application code as well as database related artifacts.

This post explains how you can recover the DB objects (Tables, Columns, Primary & Foreign keys)

Main Article

Steps to resurrect DB objects from your Entity objects:

In the Model project, create Business Components Diagram (Under ADF Business Components)
Drag all the Associations and  Entities on the diagram. This should create a Entity hierarchy in the diagram

 

dbobjects_from_adfbc_3

Now Right click on an empty space in diagram and select 'Generate Business Objects' > 'Database Objects for Diagram'

dbobjects_from_adfbc_4

This will replace any existing tables and remove data. So use this only when you need to recreate tables from scratch.

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha

Recent Content