v15 - Database Builder - View Dependencies

[Paolo F Cantoni]

Hi,
I suspect I may have used the Database Builder (DBB) incorrectly when reverse-engineering a database.  Does DBB create the view dependencies back to the source objects (that is what you find in the SQL Object Properties Dependencies box)?  If it doesn't, are these dependencies stored as repository items (and where) or are they calculated "on the fly" by the internal SQL parser?  My model doesn't have these dependencies as t_connector objects, but that may be because I mis-manipulated the import.

TIA,
Paolo

[Paolo F Cantoni]

[BUMP]

Anybody?  But especially a Sparxian.

Paolo

[Modesto Vega]

Not as far as I know. It is the same for functions, stored procedures and so on.

[Geert Bellekens]

Not as far as I know. It is the same for functions, stored procedures and so on.

Not sure, I think I remember seeing dependencies from views to tables when doing a reverse engineering of a SQL Server database, but it has been a while ago, so I'm not that sure.

Geert

[Paolo F Cantoni]

Not as far as I know. It is the same for functions, stored procedures and so on.

Not sure, I think I remember seeing dependencies from views to tables when doing a reverse engineering of a SQL Server database, but it has been a while ago, so I'm not that sure.

Geert

Yes, Geert,

That's EXACTLY my situation!  I don't have any repositories in my current engagement with visible dependencies.

Hopefully, a Sparxian can give us a definitive answer!

Paolo

[Modesto Vega]

I know what you both mean. I just checked a couple of repositories, one reversed engineered with V11 and the other with V13, this is what if found.

On the repository reversed engineered with V11
- there are no views with dependencies to tables on reversed engineered Oracle databases
- there are views with dependencies to tables for a SQL Server database but the view element does not have a DDL

On the repository reversed engineered with V13
- there are views, functions and stored procedures with dependencies to tables on SQL Server reversed engineered databases
- there are views with dependencies to tables on Oracle reversed engineered databases

The sparxian answer appears to be that

• it depends on the version of Sparx, and
• if V13 did it I would expect V14 and V15 to do it