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.

 

Add Your Comment