This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

reverse engineering /w Middlegen across multiple schemas

 
Jeevan Sunkersett
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Reverse engineering my Oracle database with Middlegen, works fine for me.

However I have the following requirements, for which middlegen gives errors/ warnings

We are developing an enterprise solution, having multiple modules.

My DBA did a re-org of the database.
So we now have a Common schema (holding all common tables) referred to by all modules
and individual schemas to hold tables of individual modules.

Now for "MY-module" we have a schema "MYMODULE" with a table MY_MODULE_TAB,
which has a foreign key relation with a common table in common schema say BANK_TAB

How do we specify such details to the middlegen ant task?

The middlegen ant task accepts userID, password and schema amongst other parameters.
followed by a list of Table names that need to be reverse engineered.

But it cannot accept a table name with schema name as classifier.


..... middlegen throws an error table MYMODULE.MY_MODULE_TAB not found


If I separate out using to 2 middlegen tasks



middlegen throws a warning;
Found a relation between MY_MODULE_TAB and BANK_TAB. Skipping it since BANK_TAB isn't among the specified tables.


Has anobody faced this scenario.
Any clues will be appreciated.

~g1
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic