What best, in our first big Enterprise Reverse Engineering?


New in ERStudio.

We have almost 8 thousands of tables, grouped by  two dozens of dbo or dbschemas, representing a few business.

Some dbschemas are commonly used, let's say, "institutional dbschema".

Two options:

A) (We have done) Reverse engineeering by business, so you will have as *.DM1 files as business you have.  Each project manager, manage their own.

 Question: How can I incorporate some relations to those "institutional dbschema"? They are in other *.DM1 File.   I'm still looking for an answer for this.  Any help, wellcome.


B) Reverse engineeering by Enterprise, so you will have just one ENTERPRISE.DM1 file and submodel every business you have with no problem about entity relations among differentes dbo's - dbschemas.

 Risk: Administration and accountability I see.   It looks like bulky, not smart.